How to perform Vlookup(Excel) same in dataiku visual recipe(Combination of recipes also)

Shankar_213_
Shankar_213_ Dataiku DSS Core Designer, Registered Posts: 1

How to perform Vlookup(Excel) same in dataiku visual recipe(Combination of recipes also)

Then only possible in code recipes or sql?

Answers

  • Turribeach
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,124 Neuron

    VLOOKUP() is how Excel works. You shouldn't try to apply solutions from other tools in a new tool. Can you please let us know what your actual requirement is? Where is the data? What are you trying to achieve? Most likely this can be done with a Join recipe but hard to say since you have not given us much information.

  • tgb417
    tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,598 Neuron

    @Shankar_213_

    Welcome to the Dataiku Community. Glad to have you join us.

    Having transitioned from Excel to Databases, I can guess that you want to connect two datasets that contain a common set of values. In the database world and in Dataiku we call this a Join.

    This knowledge base article may help you to see if a Join is what you are looking for. This has a nice video at the top.

    https://knowledge.dataiku.com/latest/data-preparation/visual-recipes/concept-join-recipe.html

    Here is a more general link to materials that may help you make the transition from MS Excel to Dataiku.

    https://knowledge.dataiku.com/latest/data-preparation/excel/index.html

    This Dataiku Academy course may also help make the transition clearer.

    https://academy.dataiku.com/excel-to-dataiku-dss-quick-start

    Finally here is a link to the documentation for Joins in Dataiku.

    https://doc.dataiku.com/dss/latest/other_recipes/join.html

    I hope one of these items might help. And welcome to the Dataiku Community.

  • tgb417
    tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,598 Neuron

    P.S. I just noticed that you have completed the Core Designer course. Congratulations! Great work!

Setup Info
    Tags
      Help me…