Hi
I have a problem with the aggregator.
I have a source from which I extract col1,col2,col3,col4,col5
i caliculate the sum of col3 with key as col1,col2
I also want to pass col4 ,col5 as I extracted from the source.
I couldnt find any option in the aggregator where in it allows me to pass a value which is not either a part of the key or an aggregated column.
please let me know if there is any way to do this
Thanks
aggregator
Moderators: chulett, rschirm, roy
That you cannot do in Aggregator stage.
But there is a work around for it.
Sort the data before in the Aggregator stage. Use a copy stage after the sort with two output links. One to Agrregator stage and one to Join stage. Pass only the key field and calculation fields to Aggrgator stage and all fields to Join stage. Give the output from Aggregator stage to join stage. Do an inner join. you will get what you want.
![Sad :(](./images/smilies/icon_sad.gif)
![Cool 8)](./images/smilies/icon_cool.gif)
-
- Participant
- Posts: 135
- Joined: Tue Aug 14, 2007 4:27 am
- Location: Mumbai
Is RCP works with Aggregator ?
Is RCP works with Aggregator ?
if yes then how ?
if yes then how ?
Thanks
Swapnil
"Whenever you find whole world against you just turn around and Lead the world"
Swapnil
"Whenever you find whole world against you just turn around and Lead the world"