To Compare two excel & get unique rows based on column

Hi Everyone,

I have two excel file. Both excel file contains Wage Type Text & Associate Name
I need to get the value which is available in dt1 & not in dt2
Similarly, the value avail in dt2 & not in dt1

D1 File looks like attached screenshot

D2 file is attached below:

The highlighted value are available only in dt2 but not in dt1 . I need to get the highlighted value as output.

Please, suggest solution for this scenario

Hi @nithya

Keep only the wage type text and associate name column in the both input table( remove the other columns) and use the following query.
dt_output1=if(dt_input1.AsEnumerable.Except(dt_input2.AsEnumerable,,dt_input1.AsEnumerable.Except(dt_input2.AsEnumerable,,dt_input1.Clone) //Returns ID available only in the first table.

dt_output2=if(dt_input2.AsEnumerable.Except(dt_input1.AsEnumerable,,dt_input2.AsEnumerable.Except(dt_input1.AsEnumerable,,dt_input2.Clone) //Returns ID available only in the second table.

Hope this helps

1 Like

Hi @Suraj_B_Shetty
Thanks for the reply.

I need to add column (A, B, D, E,G ) in Output file but based on the Column B & E Comparison.


Give a try to this.

Keep A, B, D, E and G column in the both input table
and then use the same query.

Hi @Suraj_B_Shetty
please, find the output below.

Since, its comparing with Amount also . The highlighted row should not be avil in output file because with same wage type & associate name both dt1 & dt2 contains.

Note – The comparison between two file should be based on Column B & D only not with Amount column

Then keep only two column and use the same query. Then join the dt_output2 with the dt_input2 to get the remaining data.

U can use left join and then remove duplicate column from the output table.


Can u share input file here.

Please refer to sheet 2.

SL Wage Type PP4.xlsx (9.4 KB)
SL Wage Type PP5.xlsx (10.0 KB)

Hi @nithya

Check this sample workflow
JoinEntireRow.xaml (10.5 KB)

SL Wage Type PP5.xlsx (11.3 KB)


Thanks @Suraj_B_Shetty
It worked.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.