I have a datatable with the following fields Branch, Item, Qty Brisbane, Paper, 15 Brisbane, Pens,45 Brisbane, Paper, 20 Brisbane, Marker, 50 Brisbane, Pens, 10 Brisbane, Paper 80 I want to build a query that groups by Branch and Item and also does a count of the Item. The result would look…

@craig.norton linq would fit…using build datatble create a table with 3 columns two string and one integer assign with newdt = dt.AsEnumerable.GroupBy(function(x) x("Branch").ToString+x("Item").ToString).Select(function(x) newdt.LoadDataRow({x.First()("Branch").ToString,x.First()("Item").ToString…

Grouping data with Count

Help Activities

craig.norton (Craig Norton) May 8, 2025, 1:42pm 5

@Anil_G This worked perfectly. Many thanks.

1 Like

Topic		Replies	Views
LINQ - how to count items in each group and join them Studio datatable , activities , question , linq , linq-query	10	1555	February 20, 2024
LINQ Query to Group and Sum Data in DataTable Columns Studio	3	2586	December 30, 2023
Help with LINQ Query to Group and Sum Data in DataTable Studio datatable , excel , studio , question , activities_panel , linq	7	283	August 5, 2024
Linq query group by Activities excel , studio , question	5	1478	January 26, 2021
DataTable Group By Sum and Count using Linq Help	2	5839	January 29, 2019

Grouping data with Count

Related topics