Page 1 of 1
Normalise multiple records of same file
Posted:
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
Posted:
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
Posted:
Mon Oct 14, 2013 4:40 pm
by anirban85
We cannot use RESIZE option.
Re: Normalise multiple records of same file
Posted:
Mon Oct 14, 2013 5:55 pm
by BillyBoyo
Re: Normalise multiple records of same file
Posted:
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
Posted:
Mon Oct 14, 2013 6:22 pm
by BillyBoyo
Which you can make that example do.
Re: Normalise multiple records of same file
Posted:
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.