How to get a sum of rows group by column in tMap

[MaouNory]

For example I have a table of PURCHASES on Input Database that has column: buyer_id, purchase_amount

On the output Database there is a row call total_amount and buyer_id. How can I make the total_amount column be the sum of all purchase_amount in Input Database of the same buyer_id ?

[Anonymous · Accepted solution]

Hi

Take a look tAggregateRow component, this component is used to do the aggregation operation including sum, count, max, first etc.

Regards

Shong