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.

[ggruccio · Accepted 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:

[bpatel · Accepted solution]

hi @troy_mech ,

i mocked up an example. is this what you are hoping to achieve?

hope this helps!

[troy_mech]

You are a star.

[troy_mech]

Thank you so much

[troy_mech]

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.

[bpatel]

@troy_mech ,

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!

[troy_mech]

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.

[bpatel · Accepted solution]

@troy_mech .

got it. you can add an output to the unmatched records and have that output update the input file. hopefully this helps

[troy_mech]

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.