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.
Hi @troy_mech,
I would recommend doing a Join where you Union the results that come out of the L and R sides (see below). The J will be the records that match from each table, the L and R will be the non-matches. I've attached an example yxmd as well:
hi @troy_mech ,
i mocked up an example. is this what you are hoping to achieve?
hope this helps!
@troy_mech .
got it. you can add an output to the unmatched records and have that output update the input file. hopefully this helps
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
You are a star.
Thank you so much
