aggregation rows/ summary rows

[cyclogenisis]

Have the following:

a,b,2
a,c,6
k,c,8
k,b,4

Need:

a,b,2
a,c,6
k,c,8
k,b,4
all,c,10
all,b,6
a,all,8
k,all,12
all,all,20

What is the easiest way to achieve this using parellel?

[ray.wurlod]

Begin by documenting the rules for producing the output. I don't understand, for example, where the 10 comes from in the fifth line of your output.

[anbu]

I think you should have 14 on this line "all,c,10"

Input --> Transformer ---> Aggregator --> Seq

Have three output links to transformer.

In first output link, have this mapping
Field1 --> Field1
'All' --> Field2
Field3 --> Field3

In second output link, have this mapping
'All' --> Field1
Field2 --> Field2
Field3 --> Field3

In third output link, have this mapping
'All' --> Field1
'All' --> Field2
Field3 --> Field3

In aggregator, use Field1 and Field2 as key and sum Field3