Get record count also along with SUM.

IBM's Sort Product, ICETOOL, ICEMAN and ICEGENER.
Post Reply
Suntles Singh
New Member
Posts: 6
Joined: Fri Nov 21, 2014 5:34 pm

Get record count also along with SUM.

Post by Suntles Singh »

Hi,

I know tha tusing SUM FIELDS I can sum the values in an input file in sort but how can I get the count of the fields too which are summed up? For example, if my input is like this:

Code: Select all

ABC 250 
ABC 150 
EFG 700 
EFG 100
EFG 100 
EFG 050
The output should look like:

Code: Select all

ABC 400 2 
EFG 950 4 
Please let me know if there is a way to achieve this?
User avatar
Akshya Chopra
Registered Member
Posts: 76
Joined: Mon May 20, 2013 11:32 pm
Algeria

Re: Get record count also along with SUM.

Post by Akshya Chopra »

Suntles Singh
New Member
Posts: 6
Joined: Fri Nov 21, 2014 5:34 pm

Re: Get record count also along with SUM.

Post by Suntles Singh »

Thank you so much. :)
Post Reply

Create an account or sign in to join the discussion

You need to be a member in order to post a reply

Create an account

Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute

Register

Sign in

Return to “IBM DFSort, ICETOOL, ICEMAN, ICEGENER.”