IBM Mainframe Forum

[avinashmusic]

Hi My requirement is like,

Input file

Select all

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

Expected output file

Select all

ABC 170
DEF 90
GHI 190

Could someone please help me with this?

[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.