Count unique records against 3 columns

[ppr (Peter Preuss)]

we would understand it in this direction

group the data on colA, colB
From the group members take the last member (as we do see NOK and not OK)

5699510 information OK
5699510 information NOK

dt2 =

(From d in dt1.AsEnumerable
Group d by k1 = d("ColA").toString.Trim,k2 = d("ColB").toString.Trim into grp=Group
Select r = grp.Last()).CopyToDaTable

Modify ColA, ColB name or index to your details

Also have a look here:

[HowTo] Overview on different options for grouping data and processing the groups

This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data. Introduction Grouping data and processing the grouped data is a common scenario e.g. when the grouped data is to aggregate like summing up, find maximum, get the average or concatening items. Lets have a look on following data: [grafik] A possible scenario could be: Create a report containing following information: the region code the sum of CaseCount per RegionCode t…