Visit the official Paxata Documentation portal for all of your doc needs.

Anti-Join in Paxata

Hi again everyone!  You've got to be sick of hearing from me by now.

So on the continuing monster project I've been working on, the SPSS stream that I am to match/mimic in Paxata calls for a a merge between two data sets on four keys columns.  But it's an "anti-join" between two data sets, to "include records in the first data set that do not match any others (anti-join)."  Looking at the options for Look-up, I don't see a way to do this.  Would this be done via Append instead or is there something I'm missing?  Any thoughts appreciated.  

Best Answer

Answers

Sign In or Register to comment.