LINQ for grouping, sum and copy to new DT - skip not working

[ppr (Peter Preuss)]

@Juli

why we need to use concat?

have a look here:

[HowTo] LINQ - First Start # Concat | Append | Prepend Operator

This HowTo gives an introductory overview of the conjunction operators: Concat, Append, Prepend Introduction The conjunction operators are used to add the item(s) to a particular set of items. Concat, Append, Prepend Operator The Concat Operator combines a set of items with another set of items The Append Operator adds an item to a set of items on the end The Prepend Operator adds an item to a set of items on the begin Overview I – Input P – Processing O – Output {"A","B"} / {"C",…

And

[HowTo] LINQ - First Start # Skip | Take | SkipWhile | TakeWhile Operator

This HowTo gives an introductory overview of the partition Operators: Skip, Take, SkipWhile, TakeWhile Introduction The partition operators are used to fetch a particular subset from a set of items. The returned subset is formed by the contiguous items that are matching the provided condition. Skip / Take Operator The Skip Operator will omit the subsequent items from the given start for a given length and will return the remaining items The Take Operator will return the subsequent items fr…

you had seen System.Linq.Enumerable… in the output because of:

• skip wil return a collection the itemArray items which are grabbed after skipping the first 33 items
• with Append a single item / element will be added to the ra (row array)
• the caused toString() from the complex type will be used as column value

So we changed to:

.Concat(grp.First().ItemArray.Skip(33)

as the intention is about to combine multiple elements (returned from skip) with multiple elements defined by ra1/ra2…