How to Compare two datatable, and have a single notification

[Priyanka_Ramesh]

Hi ,

This can be tried using the Linq
DTSame = DT1.AsEnumerable().Except(DT2.AsEnumerable(),System.Data.DataRowComparer.Default).CopyToDataTable

If DTSame.Rows.count>0 then “KO”
Else “OK”

Refer this link

Check two datatables are same on 2 excel files

Hi @trunghai you can do this in way Read the first excel file and store in dt1 Read the second excel file and store in dt2] To find uncommon rows between the dt1 and dt2 use the following way dt3 = dt1.AsEnumerable().Except(dt2.AsEnumerable(),System.Data.DataRowComparer.Default).CopyToDataTable Then use an if condition to check the dt3 has rows or not , if dt3 has rows then the two datatable are different if not two datatables are same Refer this workflow sample_12.zip (2.6 MB) Hope it h…