Check two datatables are same on 2 excel files

Learn Academy Feedback
7

Hi @trunghai you can do this in way

  1. Read the first excel file and store in dt1
  2. 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 helps you

Regards

Nived N
Happy Automation

3 Likes