How to merge two files on different position in file.

[Akshya Kumar]

Hi

I want to merge two files from different position in each file, is that possible? Can anybody suggest please.

Input file1:

Code: Select all

Field1 Data1 
Field2 Data2 		
Field3 Data3 
Field4 
Field5 
Field6 

Input file2:

Code: Select all

Field1 
Field2 
Field3 
Field4 Data4 
Field5 Data5 
Field6 Data6 

Expected Output File:

Code: Select all

Data1 Data2 Data3 Data4 Data5 Data6 

[William Collins]

Look at ICETOOL's RESIZE operator. Concatenate the two files for input. Specify a USING file. In that, use OMIT COND= to drop the records which have blanks, use INREC to BUILD a record which is 8,5 plus a blank. RESIZE from six to 36.

[Akshya Kumar]

Thanks for the hints William. I could spot this link http://www-01.ibm.com/support/knowledge ... erator.htm. Will work on this to make the final sort statements.