First of, Last of Aggregate Stage

myukassign · Post by **myukassign** » Tue Jul 13, 2010 1:34 am

Hi I am using aggregate stage to do some calculation. I can find that First, Last options are missing in the parellel Aggregate stage which was present in the Server version. Can you tell me to get the equivalent here.

Min and Max is there but in my case my datatype is varchar so it is resulting 0 for me.

Please help

ray.wurlod · Post by **ray.wurlod** » Tue Jul 13, 2010 1:39 am

Remove Duplicates stage.

myukassign · Post by **myukassign** » Tue Jul 13, 2010 1:45 am

Ray...

In sucha situvation like this

PID Ordercount SalesTeamMember

100 2 John_stigmata
200 7 Luka_orange
100 1 Mary_stigmata

In such a situvation I want just the sum based on PID and pick any of the SalesTeamMember for that group. How can I make use of Remove duplicate...

My output should be...

PID SumOrdercount SalesTeamMemeber
100 3 John_stigmata
200 7 Luka_orange

priyadarshikunal · Post by **priyadarshikunal** » Tue Jul 13, 2010 3:32 am

send records to two streams one to Remove Duplicate stage to pick the first/last salesteam member and second to aggregator to get the sum and then join them together on PID.

ray.wurlod · Post by **ray.wurlod** » Tue Jul 13, 2010 4:40 am

Use Copy stage to create the two streams. Use Join stage to rejoin them.