Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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.
Use a Join visual recipe and set the join type to โLeft anti joinโ.