Page 1 of 1

Normalise multiple records of same file

PostPosted: Sun Oct 13, 2013 8:26 pm
by anirban85
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?

Re: Normalise multiple records of same file

PostPosted: Mon Oct 14, 2013 3:30 pm
by NicC
You are merging records on a key - have you tried looking at the RESIZE option?

Re: Normalise multiple records of same file

PostPosted: Mon Oct 14, 2013 4:40 pm
by anirban85
We cannot use RESIZE option.

Re: Normalise multiple records of same file

PostPosted: Mon Oct 14, 2013 5:55 pm
by BillyBoyo
Because?

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

Re: Normalise multiple records of same file

PostPosted: Mon Oct 14, 2013 6:05 pm
by anirban85
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

Re: Normalise multiple records of same file

PostPosted: Mon Oct 14, 2013 6:22 pm
by BillyBoyo
Which you can make that example do.

Re: Normalise multiple records of same file

PostPosted: Tue Oct 15, 2013 6:54 pm
by dick scherrer
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.