NATURAL JOIN
Kevin_dataiku8
Registered Posts: 15 ✭
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
Answers
-
Yair Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 7 ✭✭✭
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