Page 1 of 1

Help needed regarding Sort card

PostPosted: Fri Sep 19, 2014 11:25 am
by karthikbuchi
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

Re: Help needed regarding Sort card

PostPosted: Fri Sep 19, 2014 12:12 pm
by BillyBoyo
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.

Re: Help needed regarding Sort card

PostPosted: Fri Sep 19, 2014 12:47 pm
by karthikbuchi
got it. thanks.