I have a csv file where I want to calculate the sum of a respective attribute which have the same ID. In the example below I want to sum the values of v2 and add it in the correct place for id = 22, then go onto the next "group", thanks!

id,v1,v2,v3,v4,v5

22,hi,hi,1,2,3

22,,,,,

33,hi,hi,2,3,4

33,,,,,

44,no,no,5,5,5

44,,,,,

Page 1 / 1

You can do this using the StatisticsCalculator. Group by id.

Thanks! But how do I place the values found in the empty columns in the final row of each "group"?

I probably do not understand what you need. Can you add you expected output?

id,v1,v2,v3,v4,v5

22,hi,hi,1,2,3

22,,,sumv2,summv3,sumv4,sumv5

33,hi,hi,2,3,4

33,,,sumv2,summv3,sumv4,sumv5

44,no,no,5,5,5

44,,,sumv2,summv3,sumv4,sumv5

I probably do not understand what you need. Can you add you expected output?

I still do not understand why one would want this but the attached workspace produces what you asked for.

I probably do not understand what you need. Can you add you expected output?

Thank you very much! Is part of a larger system which has its requirements, odd as they may be.

Sign up