JOIN two tables and keep results that don't match

I have a list of jobs in a spreadsheet 1 and I want to compare them with a list of jobs in spreadsheet 2 and output the ones that are missing from spreadsheet 1

I am trying to use the JOIN function to only keep rows that DON’T MATCH in spreadsheet 2 but it doesn’t look this this is an option. Is there any other way of achieving this function?

Hey Abrar! Sounds like you should use the List Contains step instead of the Join step. You’ll want to make sure to select the “Not Contains” option from advanced setting to keep the rows that do not match.

Check out the doc and accompanying video to learn more about the List Contains step:

1 Like