Not In Function when matching values of 2 datasets

Options
LaRoyce
LaRoyce Registered Posts: 1

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

Setup Info
    Tags
      Help me…