topic create sum of column without losing all the rows in Talend Studio

create sum of column without losing all the rows

simonius — Sat, 16 Nov 2024 02:05:57 GMT

Hi,

I need per row a sum of the entire collection.

The only thing I find to create a sum is with the aggregateRow. But this removes my rows. And just gives me the total.

How can I per row convert column B from single row value to the total of all rows. I need this in every row of my selected data.

Kind regards,

vapukov — Mon, 22 Jun 2020 12:15:53 GMT

Hi,

you can use tJavaFlex( or tJavaRow) between source and destination, here you just store to a variable

as an example with tJavaFlex:

in the top section:

globalMap.put("SumTotal",0);

in the middle section:

globalMap.put("SumTotal", globalMap.get("SumTotal")+row1.ColumnB);

of course, you need to control null values