How do you join but leave behind those that are already in the target?

[brendafos]

I have two files. One is the main file, the other is the add in file. But the add in file has some names (rows) which are already in the main file.

How do I bring into the main file only the new rows from the 'add in' file? 

And the two files have different columns/headers.  But there is a common field key in both files.

[PeterGoldey · Accepted solution]

Hey - I'm sure there is a more elegant way, but just with the join tool you could:

1. join the files (main file as left input)

2. discard the left and center outputs

3. the right output are your new records

You could then union the right output in with the full main file or whatever the next step in your process is.

- Pete

[brendafos]

Thank you, PeterGoldey!

That approach has worked.

You've saved my weekend.

[PeterGoldey]

Excellent!

Glad I could help.