Summation in transformer stage

[jani]

Hi All,

I am trying to sum a column without grouping.I need the summation as a single value so that i can use that as variable in calculation.Please help me out.

Thanks in advance.

[sachin1]

stage variable will help............

stage variable = stage variable + input column value

[vivekgadwal]

stage variable will help............

stage variable = stage variable + input column value

Yeah, this should work. Don't forget to initialize the stage variable to whatever value you want (ex. '0').

[jani]

stage variable will help............

stage variable = stage variable + input column value

Hi Sachin,
Sorry i did not get u.For example if Quantity is a column then i want sum(Quantity) as a single value irrespective of the other columns.

Thanks

[sachin1]

stage variable will help............

stage variable = stage variable + input column value

Hi Sachin,
Sorry i did not get u.For example if Quantity is a column then i want sum(Quantity) as a single value irrespective of the other columns.

Thanks

hello dear in stage variable palette define one variable for example sum_quant, in derivation put sum_quant + input_column_name.

in transformer put derivation for column Quantity as stage variable.

Derivation column name
sum_quant Quantity.

[ray.wurlod]

You're all crazy! Use an Aggregator stage to sum the column. Specify no grouping columns. It will use no memory (apart from the actual running sum) and be very fast. And it will require no "programming".