Help needed regarding Sort card



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Help needed regarding Sort card

Postby karthikbuchi » Fri Sep 19, 2014 11:25 am

Hi,

I have one file with below layout.

Item Cost

And that file contains same items with different cost.
Now I have to get the sum of cost field for a particular item using sort.
How can I get this?.

Example
Item cost
111 23
111 24
222 12
222 13

now I have to get output file with
Item cost
111 47
222 25

How to do this in sort card
karthikbuchi
 
Posts: 6
Joined: Mon Sep 08, 2014 10:16 am
Has thanked: 0 time
Been thanked: 0 time

Re: Help needed regarding Sort card

 

Re: Help needed regarding Sort card

Postby BillyBoyo » Fri Sep 19, 2014 12:12 pm

Since the data is in order already, look at using the OUTFIL reporting functions. You''ll need REMOVECC,NODETAIL and SECTIONS with TRAILER3 and TOT. Lots of examples around, and well-documented in the manual.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: Help needed regarding Sort card

Postby karthikbuchi » Fri Sep 19, 2014 12:47 pm

got it. thanks.
karthikbuchi
 
Posts: 6
Joined: Mon Sep 08, 2014 10:16 am
Has thanked: 0 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post