Linq Group By and Sum

[ClaytonM]

Hello,

I’m not sure this is the best way, however I got this to work by manipulating the data to a delimitted format using the below steps.

1. Store GroupBy expression to a variable of type IEnumerable< Object >
   
   

The Output of this returns:

2. Concatenate the header to the items in the list using .Split and .Select

• You can split by comma, then use Select, and select the item split by “=”
  
  

Without the headers, we have this:

So our new output looks like this with headers:

3. Lastly, convert to a table.

• Using either Generate Data Table or Write Text File / Read CSV

I chose to use Write Text File because I have issues with Generate working.
So below shows an example of this.

Hopefully this is helpful.

Thanks, and Regards.

C