Compare two lists, but remove duplicates before join

Question

Quick question.  I am combining two sources of data, Source A and Source B.  How can I compare the two sources and see if a Customer ID exists in both and if so, leave the one in Source B out when combining so that there are not two records for the Customer?

abe_ibanez · Answer

Hello, 
If you use a Join tool, it will not combine the data from both sources in the J output anchor; just the ones you select within the Join tool.

Here is an example:

Source A (Top):

Join Tool configuration:

Output after Union tool:

I hope this helps.

binu_acs · Answer

@RCern @Can you explain your use case with an example for better understanding

RCern · Answer

@binu_acs But then how do I exclude those specific matched Customer IDs from the combined list of both sets?