I have a large Excel worksheet (10,000+ rows, 170 columns.) I have a second, smaller Excel worksheet containing records that I need to exclude from the larger worksheet. I would like to be able to create a Left Excluding Join to remove the intersection of the the two files and retain only unique records from the larger file. The larger worksheet is static, only changing when records need to be removed using the smaller file. I remember something about an 'Exclude' option mentioned at TC16 but I cannot find it anywhere!
Thank you in advance!
If you do a left join, on the top right of the data connection page you should see the ability to add filters. In that menu should be the ability to exclude certain fields.