MVSFORUMS.com

dkaruna · Beginner Joined: 02 Dec 2002 Posts: 2 Topics: 2

I have three files and i want do a vertical merge based on the key. if a record is missing in one of the file a low value should be sustituted for corresponding fields.In the below example position 1 is the key for all input files. The output file should be a mege of input file 1 , 2 and 3.

Example explained below.

For eg

Input 1
1 aaa
2 bbb
3 <space>
4 ddd

Input 2
1 222
3 333
4 444
5 555

Input 3
1 xxxx
2 zzzz
3 yyyy
5 nnnn

Output
1 aaa......................111.......................xxxx
2 bbb......................<lowvalues>..........zzzz
3 <space>...............333.......................yyyy
4 ddd.......................444.......................<lowvalues>
5 <lowvalues>.........555........................nnnn

I have searched the forum and could not find exact result for me. I would appreciate your help.

Thanks
_________________
Thanks & Regards
Karuna

programmer1 · Beginner Joined: 18 Feb 2004 Posts: 138 Topics: 14

Is there a range specified for the key field ? Does any of these 3 input files contain all the key field values ?

If I was you, I would have preferred to write a program for this.
_________________
Regards,
Programmer

kolusu · Posted: Thu Feb 10, 2005 8:18 am Post subject:

dkaruna,

Please follow the rules. Do not open more than topic which discusses a similar issue. Also this topic has been discussed many times. check this link

http://www.mvsforums.com/helpboards/viewtopic.php?t=10&highlight=merge

http://www.mvsforums.com/helpboards/viewtopic.php?t=974&highlight=merge

Hope this helps...

Cheers

kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu