Hi,
Wondering if someone would be able to help me. I’m trying to Import , Group, Sum and then Export a CSV. The problem is that my CSV has a unknown number of columns of the following format.
GroupA,GroupB,GroupC,ValueA,ValueB,ValueC,ValueD…
GroupA, B and C are constant and the fields I want to group by - I know the names of these fields in advance. The problem is there are an unknown number of Value columns - all of which I want to Sum (and don’t know the names of in advance.)
I’m comfortable getting this code working if I know the name of the Value fields and have a fixed number of Value Fields. But I’m struggling to get code for unknown names and number of columns.
Any help would be appreciated,
Sam