Home Data Prep Q&A

Paxata Community Members: Something special in a community experience is coming your way. Stay tuned to this space.
In the meantime, check out the brand new Data Prep for Data Science topic here and the new DataRobot Community.

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


Sign In or Register to comment.