I am looking for a sort job that can do subtotal for me.
Sample input file
A 100A 200A 300B 100A 200B 500
Sample output file
A 800B 600
I think this can be achieved by using syncsort SUM function, can someone share me an example for doing the subtotal using syncsort.