How to find common rows between two datatables using LINQ?

[supermanPunch (Arpan)]

Hi @Sravani_Reddy ,

You could maybe check with the below post :

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

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. [image] [UiPath- How to Compare two Data Tables| Output the similar and dissimilar rows |Faster method]

Additionally, If Specific column match is required, we could use Join Datatables Activity and if not the expected output we could go for a Linq Join