Get record count also along with SUM.

IBM's Sort Product, ICETOOL, ICEMAN and ICEGENER.
Previous topicNext topic

Topic Author
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 » Wed May 03, 2017 11:52 am

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: 56
Joined: Mon May 20, 2013 11:32 pm
Zodiac: Leo

Re: Get record count also along with SUM.

Post by Akshya Chopra » Wed May 03, 2017 1:38 pm





Topic Author
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 » Wed May 03, 2017 1:42 pm

Thank you so much. :)



Previous topicNext topic

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