Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

how to join two table and remove matching records

troy_mech
8 - Asteroid

I have Table1 and Table2 have three columns each. I want to join the two table and to remove the record which are matching in Table1, Column A and Table2. Column A. Finally I have to add those unmatched records into another Table3.

11 REPLIES 11
bpatel
Alteryx Alumni (Retired)

you can if you want too, however even if table 2 has more columns the process should work. you will see null values in you new table 2 for any missing information in the additional columns

bpatel_0-1596221339298.png

 

troy_mech
8 - Asteroid

Thank you so much again. Shall I use the updated file again as input file for joining with another table3 in the same workflow?

Labels
Top Solution Authors