Finding the similar columns between two different sheets

[Gokul001 (Gokul Balaji)]

Hi @Rawan_Ghurab

Can you share the sample input and expected output?

How about this expression?

DT_Final = DT_2.AsEnumerable.Where(Function(r) not DT_1.AsEnumerable.Any(Function(r2) r2("Phone").ToString=r("Phone Number").ToString)).CopyToDataTable.DefaultView.ToTable(False,{"Date","Phone Number","Currency"})

You can check out this thread

Removing duplicates

Hi, How about the following? [image] 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,

Regards
Gokul