In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Compare two lists, but remove duplicates before join

RCern
8 - Asteroid

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?

4 REPLIES 4
binuacs
21 - Polaris

@RCern @Use the join tool and join with the customer id as key, deselect the right customer id field from the join tool configuration, the J-anchor will have the output which matching customer id records from both sources

RCern
8 - Asteroid

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

binuacs
21 - Polaris

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

abe_ibanez
9 - Comet

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: 

image.png

 

Source A (Top):

image.png

 

Join Tool configuration:

image.png

 

Output after Union tool:

image.png

 

I hope this helps. 

Labels
Top Solution Authors