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: https://parabola.io/transforms/list-contains (Edit on 11/30/20: The List Contains step has been renamed to the Find Overlap step, and you can find the relevant documentation here: https://parabola.io/transform/find-overlap)
I’m trying to do the same thing, but looks like List Contains no longer exists.
Hi @Nathan_Lively – yes, you’re right that it no longer exists by this name. After improving this step, it was renamed to “Find overlap” to match its functionality more: https://parabola.io/transform/find-overlap
We understand that step renames can be inconvenient at times. If helpful to know, a flow builder’s toolbar will continue to show the step by its previous or new name:
Community Announcement posts, your account’s flow page right-side Updates section, Parabola blog posts, and newsletter emails aim to minimize this confusion, though we’ll continue to work on finding other ways to lessen this confusion. Thanks for your understanding with this!