Not In Function when matching values of 2 datasets
Hello, im a very new user of DataIku, but experienced in writing SQL.
I have a use case where i need to match the IDs of Table A to the IDs of Table B, and exclude the records in Table A which are matching with Table B.
In SQL, i would usually just do a Where Table A.ID NOT IN Table B.ID, but in DataIku, i dont see any functionality that would let me do so directly?
Seems that i would need to join the tables first and then exclude, which i find odd as usually when writing in SQL, we normally use joins when we want to enrich the primary table and output columns which are existing from joined table. In my use case, i just wanted to filter out.
Hope someone could enlighten me in this.
Regards,
La Royce.
Answers
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,981 Neuron
Use a Join visual recipe and set the join type to “Left anti join”.