Get Unique Rows/Count from DataTable

Help Studio
1

Hi all,

I’m having a complete brain-freeze today and cannot work out how to count the number of unique rows in a datatable.

I have an existing table like this:
image

And I need to get it to this:
image

Any help would be appreciated, thanks! :slight_smile:

2

@adam.williamson

Check below

Hope this helps you

Thanks

1 Like
3

@adam.williamson
Customized to your case:
(From d In dtData.AsEnumerable
Group d By k1=d(“Postcode”).toString.Trim, k2=d(“Peril”).toString.Trim Into grp=Group
Let ra = New Object(){k1,k2,grp.Count}
Select dtStatistic.Rows.Add(ra)).CopyToDatatable

1 Like
4

Thank you!

5

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