Compress the data table against common ID

[Huzaib_Umar]

I need to store all values against a single ID in one row.
EX - 101 David WP3 London Australia

[postwick (Paul Ostwick)]

Use Filter Data Table to create four different tables. Each one you’ll keep only ID and Name, ID and Emp Level, ID and Depute Location, ID and Country.

Then Join Data Table three times to join DT_Name, DT_EmpLevel, DT_Depute_Location, DT_Country on ID. Note that after each join, you’ll need to remove the extraneous column that the Join creates.

[ppr (Peter Preuss)]

We assume

• that excel data is read in within a datatable
• ID column will be the first column

In general we would do:

• grouping the data
• processing the group members and flatten the columns, by catching on non-blanks

Grouping the data: (Non-LINQ, LINQ)

[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…

Group Member Processing

• Essential or with LINQ