How to SUM the values using syncsort

elijarajesh.mf · New User Joined: 02 Feb 2010 Posts: 14 Location: hyderabad

I would like to add a field based on two fileds in syncsort. Please find the below example:
A B C D
------- --- ----------------- ------
M0001 1 SWITCHING CA 19999
M0001 1 SWITCHING CA 19999

In this example I want to sum the coluomn B based on Column A & Coloumn D. If A & D matches then ADD B. Please suggest how to write this using syncsort.

Thanks,
Rajesh.

prasanth_thavva · New User Joined: 28 Jul 2005 Posts: 86 Location: Chennai

Can you post the field length and also post your control which you are trying to acheive the result.

On response to this, pls post and input and out put expected results.
that will help us to fine tune ur control card.

elijarajesh.mf · New User Joined: 02 Feb 2010 Posts: 14 Location: hyderabad

After sorting I want to get the record like this:

Input:

A B C D
------- --- ----------------- ------
M0001 1 SWITCHING CA 19999
M0001 1 SWITCHING CA 19999

Expected output:

A B C D
------- --- ----------------- ------
M0001 2 SWITCHING CA 19999 --------> In Column B values is 2 now with single record.

Lengths:
Coloumn A -----> 5 BYTES
Coloumn B -----> 3 BYTES
Coloumn C -----> 13 BYTES
Coloumn D -----> 5 BYTES.

Thanjs,
Raj

Bill Woodger · Posted: Thu Jul 07, 2011 12:07 pm

If you use the CODE tag when you submit your post, it will keep all your formatting.

When posting, highlight the text for your example data and click on Code button, around about the middle and above the input box.

This is Syncsort, so off to the JCL forum soon, I'd guess.

prasanth_thavva · New User Joined: 28 Jul 2005 Posts: 86 Location: Chennai

Post ur Control card that are currently working on to acheive the result
this can be acheived using sort and sum fields

dbzTHEdinosauer · Posted: Thu Jul 07, 2011 12:32 pm

assume you will never have more than 999 of the same key.