Hi
I have an input of 5 fields to the aggregator stage of which 3 I am using the group by function and 1 field I am suming up the input field to an output field.
Now the remaining one field I would like to count the no. of rows (i.e. have a counter to count the no. of records in the grouping ) that were in the group by clause.I see that I could not use both summation of a field and counting of the rows for another field in the same aggregator stage.
Is it possible to do it in the same aggregator or use another one?
aggregator stage (count the no. of rows)
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom