Removing duplicates

[Prasanth_98 (Prasanth S)]

Hi all,
I have two different Excel sheets with the same headers & I want to remove duplicate value rows in a particular column with the comparison of those two excel sheets, guys can you please help me with this…?

Thanks in advance

[Gokul001 (Gokul Balaji)]

Hi @Prasanth_98

Can you provide the sample input excel file and expected output?

Regards
Gokul

[Gokul001 (Gokul Balaji)]

Hi @Prasanth_98

How about this expression?

dt1.AsEnumerable().Intersect(dt2.AsEnumerable(),System.Data.DataRowComparer.Default).CopyToDataTable

Check out this XAML file

Common&UnCommon.xaml (10.0 KB)

Output Snap

Regards
Gokul

[Yoichi]

Hi,

How about the following?

dt2  = dt2.AsEnumerable.Where(Function(r) not dt1.AsEnumerable.Any(Function(r2) r2("Transaction ID").ToString=r("Transaction ID").ToString)).CopyToDataTable

Sample20221205-8.zip (44.7 KB)

Regards,

[Prasanth_98 (Prasanth S)]

@Yoichi
Thank you so much for your help