IBM Mainframe Forum

I had accidentaly posted this query in DFSORT forum.
Re-posting in Syncsort

Hi,
I have multiple records for a given account id and trying to combine all records related to each
account into one single record. Number of records for each account may vary from 1 - 4. Can
someone please help to do this using syncsort?.

Input:
Fixed 19 record length file. No header & trailer record in the file.
3 - input fields with their record position



Expected output:
6 - output fields


Any help will be greatly appreciated.
Thank you.

So, in your other post the data was coded up so that some semblance of normality was achieved with your code/input/output. Why could you not do it yourself? Use the full editor, select the data to be coded and click the Code button. Click preview to see how it looks and adjust as required. Then we can see what you are trying to do. Edit: I have spent a considerable amount of time lining things up - hopefully correctly. (Hmmm, maybe I should charge for that!)

Now I see the first amount is to go in the amount 4 column - why? What are the rules for getting from input to output?

Hi Nic,

I had coded the data myself in the first post.
The value in the amount column is based on the Flag2. If Flag2 has a value of 1 then the amount value is written in Amount (1) field and if the Flag2 value is 4 then amount value gets written to Amount (4) column.

Dhiren wrote:The value in the amount column is based on the Flag2. If Flag2 has a value of 1 then the amount value is written in Amount (1) field and if the Flag2 value is 4 then amount value gets written to Amount (4) column.

It would seem, looking at the input and output you provide, that this statement is wrong, and that the actual logic is

Dhiren wrote:Hi Nic,

I had coded the data myself in the first post.
The value in the amount column is based on the Flag2. If Flag2 has a value of 1 then the amount value is written in Amount (1) field and if the Flag2 value is 4 then amount value gets written to Amount (4) column.

You probably don't understand about the "Code".

Here is an example of what happens with the Code button.



The last two lines of text are identical. In the second, the spacing is "preserved". Which makes it a good way to "mark-up" code and data so that they line-up character-for-character in columns, just like your mainframe screen.

I Code'd your first post.

Hopefully this makes sense.
I have corrected my Output

So, it looks like your key is Code# and Flag1.

Still, how do you determine which amount is which? You show values in amounts 1, 2 and 4, but flag2 values of only 1 and 4?

Hi Billy,
Yes the key is the combination of Code# nd Flag1.
For every key record, we check the value of Flag2 and the based on the value of Flag2, the amount value is written to either Amt 1 or Amt 2 or Amt 3 or Amt4.
In the preceding example, For Key value 1210 1 we have one row with Flag2 value of '4' therefore the Amount4 is written.
For key value of 1213 2, we have two Flag2 values (1 and 4) therefore the output shows Amt1 and Amt4 populated.

Thanks.

And for 1210 2, where your have amounts 2 and 4?

For 1210 2 , we should have Amt1 and Amt4 based on Flag2 values of 1 and 4.