Linq query to merge datatable in single row based on condition

[ppr (Peter Preuss)]

@Akshay_Suryawanshi

It is not recommended to to do all processing within a single LINQ. The Main Building blocks could look like this:

Grouping the data with a LINQ and processing the group and its members within a for each

Checking the types we can do:

the sample was done for the first group

for other group processing find some starter help here:

Intro_GroupBy1Col_grpProcessing.xaml (13.0 KB)

Also have a look here:

[HowTo] LINQ (VB.Net) Learning Catalogue

This topic references the different Learning HowTos related to LINQ. It will be updated on new published HowTos as well LINQ Learning: Topic LINK First Start with LINQ [HowTo] - First Start with LINQ (VB.Net) Exploring the LINQ universe [HowTo] - Exploring the LINQ Universe (VB.Net) Operator [HowTo] Overview Topic LINK Where [HowTo] LINQ - First Start # Where Operator Select work in progress Any [HowTo] LINQ – First Start # Any Operator All [HowTo] LINQ – First Start…