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

[Shankar_213_]

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

Then only possible in code recipes or sql?

[Turribeach]

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]

@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]

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