Calculating the sum of rows in a particular column

Hope · Post by **Hope** » Thu Aug 30, 2007 8:45 am

I have to calculate the sum of all the rows in a particular column .If I use the Aggregate Stage I have to provide the grouping key but there is no Grouping key.it is simply calculating the sum of all rows in a column of a source file. Can I use the aggregator stage for this ?

Please help.

sud · Post by **sud** » Thu Aug 30, 2007 8:52 am

In a transformer prior to the aggregate stage you can create a column with a high wired value of 1 and use that as the grouping key.

Hope · Post by **Hope** » Thu Aug 30, 2007 11:31 am

Thanks

Hope · Post by **Hope** » Thu Aug 30, 2007 11:47 am

Hope · Post by **Hope** » Thu Aug 30, 2007 2:30 pm

I tried the logic which was suggested. I was able to do it.

Thanks for the help.

DSXchange

Calculating the sum of rows in a particular column

Calculating the sum of rows in a particular column

Re: Calculating the sum of rows in a particular column