Hello, I have a datatable composed of 4 columns, as in the image: [image] I need to group the rows that have the same “Number” AND “Name” and “Code” column values as follows: [image] The result in the example should return me 8 datatables. Any idea to achieve this? Thanks!

Datatable - Grouping Data on 3 Columns - Split on different Data Tables

ppr (Peter Preuss) March 9, 2022, 1:56pm 5

assign Activity
LHS: TableList | List(of DataTable)
RHS

(From d in YourDataTableVar.AsEnumerable
Group d by k1=d("Name").toString, k2=d("Number").toString, k3=d("Code").toString into grp=Group
Select t=grp.CopyToDataTAble).toList

Also Have a look here:

2 Likes

Topic		Replies	Views
How to split datatable based on Group by and values in a column in Linq Query? Please Help Help	5	3085	August 16, 2020
Group Datatable Activities datatable , excel , activities , bug , datatable-filter	5	497	January 28, 2024
Linq Query, Please Help! Reboot Your Skills 2021 week-4	8	1985	May 5, 2021
How to group by multiple columns from a datatable Activities datatable , excel , activities , question	5	7479	December 23, 2020
Split Datatable with LINQ Activities other	10	763	December 8, 2023

Datatable - Grouping Data on 3 Columns - Split on different Data Tables

Related topics