Count specific column value

Help Activities
, ,
6

HI,

Can you try the following expression?

dt.AsEnumerable.GroupBy(Function(r) Tuple.Create(r("id").ToString, r("country").ToString)).Select(Function(g) dt.Clone.LoadDataRow({g.key.Item1.ToString,g.Key.Item2,g.Count.ToString},False)).CopyToDataTable()

Sample20221018-3v2.zip (2.8 KB)

Regards,

1 Like