File sorting and summing up values at specific location

kenshin · Posted: Wed Sep 23, 2015 2:14 am

Hi All ,

I need your help in achieving following results.

Input file:
A 10
A 20
A 30
B 05
B 10
C 30

Output file:
A 60
B 15
C 30
Total 105

can the total be added by adding trailer ?
could anyone help me out with this?
[/code]

Bill Woodger · Posted: Wed Sep 23, 2015 3:36 am

Yes, OUTFIL reporting features. REMOVECC, TRAILER1 with TOT(AL), TRAILER3 with SECTIONS for your key, and TOT again.

kenshin · Posted: Wed Sep 23, 2015 5:14 am

Thank you for quick response ,Bill

I will try adding the keywords you mentioned in my sort card and will share my results.

Thanks
Sumedh

kenshin · Posted: Sat Sep 26, 2015 9:29 am

It worked !!

SORT FIELDS=(56,2,CH,A,2,6,CH,A)
SUM FIELDS=(59,7,ZD)
OUTREC OVERLAY=(59:59,7,ZD,EDIT=(IIIIIIT))
OUTFIL FNAMES=SORTOUT,REMOVECC,
TRAILER1=(22:'TOTAL HOMESAVER RECORDS
TOT=(59,7,UFF,EDIT=(IIIIIIT)))

Thanks Bill