Submit your innovative use case or inspiring success story to the 2023 Dataiku Frontrunner Awards! LET'S GO

NATURAL JOIN

Kevin_dataiku8
Level 2
NATURAL JOIN

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

0 Kudos
1 Reply
Yair
Level 2

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 🙂 

 

0 Kudos