I need help here.
I have everyday around 5000 rows of which I need to identity the duplicated row based on the value of a specific column, say “column 1”. I tried the following expression and it works for small datatable:
duplicatedDT = dt.AsEnumerable.Where(function(y) dt.AsEnumerable.Count(function(x) x(“Column 1”).toString=y(“Column 1”).toString)>1).CopyToDataTable()
but when I apply it to the real datatable, the script stucked for more than 10 minutes until I had to stopped it.
Do you guys have the better expression for this?
Appreciate your help.