IBM Mainframe Forum

Hi,

I am trying to normalize a flat file which has the below records -

12345 ANIRBAN IND
12345 ANIRBAN 176213
12345 ANIRBAN 18121985

I want the output file to look like -

12345 ANIRBAN IND 176213 18121985

Can you please help with the sort-card?

You are merging records on a key - have you tried looking at the RESIZE option?

We cannot use RESIZE option.

Because?

You can try to apply this one: dfsort-icetool-icegener/topic9498-10.html#p47015

i want to format the data, the data looks like this -

12345 date1 var1 date2
12345 date1 var2 date2
12345 date1 var3 date2

i want the data to look like -

12345 date1 var1 var2 var3 date2

Which you can make that example do.

Hello and welcome to the forum,

What might be the next addition to the scope? Your 2 sets of "input" are not the same. . .

Whwere are you stuck? Post what you have tried (jcl and sort control statements) from the link BB provided and explain where there is a problem.