How to perform Vlookup(Excel) same in dataiku visual recipe(Combination of recipes also)
How to perform Vlookup(Excel) same in dataiku visual recipe(Combination of recipes also)
Then only possible in code recipes or sql?
Answers
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,757 NeuronOptionsVLOOKUP() 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 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,595 NeuronOptionsWelcome 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 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,595 NeuronOptions
P.S. I just noticed that you have completed the Core Designer course. Congratulations! Great work!