Shell Programming and Scripting

Hi,

Please help, this is quite complex, I dont know how to start.
The original input files are 10mb in size each.


I have multiple files and I want to merge them in the following way.
Every file has 4 columns. Col1 and col2 are fixed with respect to each other. In the example value A and B in col 2 always come with value 1 in col 1, C and D in col 2 always have 2 in col 1.
The columns must be ordered, the 3rd col and the 4th col of all files stay together.Header must be formed (like example)with file names appended by col number. col 2 does not repeat within a particular file.
Original input files do not have header.

Code:

 
cat File1
 
1 A 2 4
1 B 1 2
 
cat File2
 
1 B 1 4
2 C 2 4
 
cat File3
 
2 C 5 6
2 D 4 5
 
Expected output
 
col1 col2 File1col3 File2col3 File3col3 File1col4 File2col4 File3col4
1 A 2 0 0 4 0 0
1 B 1 1 0 2 4 0
2 C 0 2 5 0 4 6
2 D 0 0 4 0 0 5

what have you tried so far? If you can post your effort we can direct you in right direction..

Code:

awk '{for(i=3;i<=NF;i++){A[$1,$2,FILENAME,i]=$i};B[$1,$2]++;C[FILENAME]++}
    END{for(ind in B){split(ind,P,SUBSEP);S=P[1]" "P[2];
    for(i=1;i<=2;i++){for(file in C){
    t=A[P[1],P[2],file,i+2]?A[P[1],P[2],file,i+2]:"0"
    S=S" "t}}print S}}' File1 File2 File3

1 B 1 1 0 2 4 0
2 C 0 2 5 0 4 6
2 D 0 0 4 0 0 5
1 A 2 0 0 4 0 0