Sort datatable 3 times

[atomic]

Before I can start the comparison I need to process the rows that are of the same UNIT, ID and TASK. What is the easiest way to handle rows with the same UNIT, ID and TASK, Im thinking to get them into a separate Batch/table and then perform the needed processing.

The processing is based on the column TASK and SUM and that why I need to have the same UNIT, ID and task before I can do the rest.

[ppr (Peter Preuss)]

@atomic
on the first look a LINQ Statement formulating a group by could help
Have a look here as well:

[HowTo] Overview on different options for grouping data and processing the groups

This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data. Introduction Grouping data and processing the grouped data is a common scenario e.g. when the grouped data is to aggregate like summing up, find maximum, get the average or concatening items. Lets have a look on following data: [grafik] A possible scenario could be: Create a report containing following information: the region code the sum of CaseCount per RegionCode t…