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 !
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 🙂
Post a Question