Page 1 of 1

Sum a set of records

PostPosted: Mon Feb 02, 2015 7:40 pm
by avinashmusic
Hi My requirement is like,

Input file

ABC Maths 90
ABC English 80
DEF Maths 90
GHI English 70
GHI Maths 50
GHI Science 70


Expected output file

ABC 170
DEF 90
GHI 190


Could someone please help me with this?

Re: Sum a set of records

PostPosted: Tue Feb 03, 2015 3:13 pm
by BillyBoyo
You're going to need to use PARSE, data-type of UFF, OUTFIL reporting features, REMOVECC,NODETAIL,SECTIONS (for your key) and TRAILER3 with TOT/TOTAL. Try to get the spec changed so that the totals do not have to be left-aligned.