DSXchange

Hi,

I want to sum of more than one input column in same output column by useing Aggregator stage.

ex: select sum(col1+ col2) group by col3.

Please help me.

Please post a sample of your data and the expected output. The question is ambigous and not very clear.

Sum them separately then sum the results. You can't do it in a single pass unless you've calculated (col1 + col2) upstream of the Aggregator stage.

The latter seems like the best solution to me... sum them first upstream and then Aggregate them.