aggregator question

dnat · Post by **dnat** » Sun Dec 27, 2009 9:32 pm

Hi,

I am doing rollups from the incoming records.

I have a group based on which i am summing multiple columns and output the same in multiple columns and finding the count. Can we do this using one stage or do we need multiple stages.

Ex:

Col A|Col B|Col C|Col D|Col E
aaaa|bbbbb|1234|3456 |654
aaaa|bbbbb|456 |980 |908

It is grouped based on col A and Col B

The output should be

Col A| Col B| Tot 1|Tot 2| Tot 3|Count
aaaa|bbbbb |1690| 4436| 1562| 2

I need this output for each group. I have nearly 50 columns where i need to do a total.

gssr · Post by **gssr** » Mon Dec 28, 2009 1:14 am

You can do it in a single aggregator stage for all your calculations

ray.wurlod · Post by **ray.wurlod** » Mon Dec 28, 2009 4:00 am

... but you will need a separate Column for Calculation for each calculation - just as you would if you were doing it in SQL or using any other tool.