I had a ExtractDataTable. I want to compare each row data is it same or different

[Puneet_Singh1 (Puneet Singh)]

I had a ExtractDataTable. I want to compare each row data is it same or different. In case of different i want to copy the data and save the same in excel. how we can do this

[Rahul_Unnikrishnan]

Hello @Puneet_Singh1 ,

You can watch the below video to solve your issue. Else you can use the expression as below.

You can use a assign activity .

DT1.AsEnumerable.intersect(DT1.AsEnumerable,System.Data.DataRowComparer.Default).CopyToDataTable

DT1 is the datatable which you get after reading the excel.

UiPath- How to Compare two Data Tables| Output the similar and dissimilar rows |Faster method

[postwick (Paul)]

The search box is your friend

https://forum.uipath.com/search?q=compare%20datatables