Identify duplicate rows in datatable

[divya_Bhat]

Hi All,

I have datatable of 10k records. and there could be duplicate rows in the datatable. NOTE : the rows get ruled out as duplicate when column “SSN” and “Start Date” have same values for 2 or more rows. Due to this condition i cant use “Remove duplicate datarows” activity.

Please help.

Thanks

[pavithra_pavi]

HI @divya_Bhat ,

Please check this article on how to get duplicate rows using LINQ

Get the duplicate rows and non- duplicate rows

Get the duplicate rows and non- duplicate rows. Im back with another solution for our problem with datatable. I.e. Getting the duplicate rows and non- duplicate rows. We all know one simple approach of getting these details, i.e. For each loop. This approach is okay when we deal with small amount of data. But what if, we are dealing with huge amount of data. And that’s where LINQ come into picture. Watch the video to learn more about this LINQ query. Also, get the code [Get duplicates…

I have created YouTube video for the same

Get duplicates and non duplicate rows using Uipath