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.
Solved! Go to Solution.
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:
You are a star.
Thank you so much
I have extracted unmatched values from Table 1. I need to add those values in Table2 but the file is being used by alteryx. One more challenge is Table 1 have three columns A, B and C whereas Table 2 have six columns A, B, C, D, E and F.
what if you try this.. take the unmatched records and add them to table 2. i updated the sample workflow. let me know if this helps!
Here I'm comparing two tables, one is retrieved from excel file. Post comparing matching values, need to add unmatched values from Table 1 (Left join) need to be added in the existing file.
got it. you can add an output to the unmatched records and have that output update the input file. hopefully this helps
Sorry for coming again, Do I need add "Block Until Done” tool before the output tool. Table1 have three column and how this will add into Table2 which have six columns.