NATURAL JOIN

Kevin_dataiku8
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
    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

Setup Info
    Tags
      Help me…