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.
Calculating the sum of rows in a particular column
Moderators: chulett, rschirm, roy
Re: Calculating the sum of rows in a particular column
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.
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.