Update the data in csv

Help Activities
, ,
1

1.Retrieve the rows that contain duplicate values in the “ID” column
2.also check in Location column Location are same if location are different then this is different set

2

Hi @Garyy ,

Is it possible to provide us with the Sample Input and Output data in the form of Excel sheets so that we could better identify the logic required to update the rows.

4

@Garyy

I believe this is what you need

Dt = dt.AsEnumerable.GroupBy(function(x) x("ID").ToString+x("Location").ToString).Where(function(x) x.Count>1).Select(function(x) x.First).CopyToDataTable

Cheers

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.