aggregator stage (count the no. of rows)
Posted: Tue Mar 01, 2005 9:26 am
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?
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?