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!
I'm writing to you because I don't think we can do natural join? Indeed, I need it to realize my ETL.
Thank you very much for your future answers !
Kevin
Hey, I don't think Dataiku has a natural join for Visual recipes,
- you can use a Joins Visual recipe, it will select the same columns automatically. (But this is not a natural join, it is just on the first selection for the join)
"If the datasets share column names, those columns will be selected by default" (https://doc.dataiku.com/dss/latest/other_recipes/join.html)
- you can just use an SQL recipe for natural join (if you work on SQL) and write it in SQL.
- you can also preform it using Python and pandas.
Hope it help ๐