Compare two files and have the output be the data from one file if it's NOT in the other

[gtoribio1]

Hello, 

I am trying to compare two files (File A and File B) and i only want the data in File A if it is NOT in File B. 

What i have done so far is combined both files using "Join".

Thanks!

[DataNath · Accepted solution]

Hey @gtoribio1, depending on which way round you have plugged the data in to the Join input anchors, the data that doesn’t match will either come out of the top (L) output anchor, or the bottom (R) output anchor. The middle anchor (J) is where a match was found and the data is joined, the L anchor is data that goes into the top input anchor and doesn’t find a match and the R anchor is the same for data going into the bottom input anchor. Here's a quick example:

My left input:

Right input:

We conduct the join on [Name] and so only the 'B' is present in both for a join:

Records from the left input that didn't find a match come out of the top L anchor:

And the same for the right:

[gtoribio1]

Thank you!

That makes sense!