how to join two table and remove matching records

[troy_mech]

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.

[bpatel · Accepted solution]

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

[troy_mech]

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