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
First of, Last of Aggregate Stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 238
- Joined: Fri Jul 25, 2008 8:55 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 238
- Joined: Fri Jul 25, 2008 8:55 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
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
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: