Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
How to perform Vlookup(Excel) same in dataiku visual recipe(Combination of recipes also)
Then only possible in code recipes or sql?
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.
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.
P.S. I just noticed that you have completed the Core Designer course. Congratulations! Great work!