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:

@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

Get Unique Rows/Count from DataTable

Help Studio

Srini84 (Srinivas Kadamati) September 17, 2020, 11:13am 2

@adam.williamson

Check below

Hope this helps you

Thanks

1 Like

Topic		Replies	Views
How to get the count of each unique value occurrences in data table column using linq query? Studio studio , question	3	866	August 2, 2023
Get unique rows and their count as a datatable Something Else datatable , studio , feedback	5	1439	February 12, 2022
Get count of duplicates from a datatable Studio datatable , excel , studio , question , activities_panel , help , linq	39	2571	March 28, 2023
How to get only the unique record in Datatable Studio studio , question , activities_panel	5	230	January 14, 2024
How to get the count of the duplicate columns from a DT Studio studio , question , activities_panel	3	780	August 26, 2022

Get Unique Rows/Count from DataTable

Related topics