How do I do an anti join? I want to find all the rows in a dataset whose key values do not appear in another dataset.
If A contains rows with key values:
And B contains rows with key values:
A anti-join B gives rows with key values:
B anti-join A gives rows with key values:
You can do an anti join using the Subtract transform.
Make sure the original dataset is above the other dataset in the center pane. So for A subtract B:
anti-join.transform (2.1 KB)
A question for @Admin , is it possible to “see” what has been subtracted ? I can see X rows have been removed , but cannot figure how to see the content of which ones
Yes, just use a second Subtract:
Oh my ! IT works , Thank You