Survey banner
The Dataiku Community is moving to a new home! We are temporary in read only mode: LEARN MORE

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

Shankar_213_
Level 1
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?

0 Kudos
3 Replies
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.

0 Kudos
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.

--Tom
tgb417

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

 

--Tom
0 Kudos