Hello everyone,
I have a data table as shown in the picture. I want to group this table according to the “Directorate” column. The rows with “Maintenance” in the column must be in a data table.
Can you create a LINQ query about the situation?
Thank you in advance for your help.
Best Regards,
@Salim_Atakan
Dt.AsEnumerable.GroupBy(function(x) x("Directorate").ToString).ToDictionary(function(x) x.Key,function(y) y.CopyToDataTable)
Now use this expression in the for loop in argument
And inside loop currentitem.Value will give the datatable for each geoup for eqch iteration
Cheers
