Shell Programming and Scripting

Hello ,

I have three files :


sampleoutput1.txt has columns (in the following order) :

Code:

hostname ; available patches , available packages

sampleoutput2.txt has columns (in the following order) :

Code:

hostname ; patchwave ; BSID ; Application

sampleoutput3.txt has columns (in the following order) :

Code:

boottime ; hostname

I am trying to join three files on the column hostname from the three files.
I want the output records as follows :

Code:

hostname;available patches;available packages;boot time;patchwave;BSID;Application

Below is the script. Here I am first trying to join the files : sampleoutput1.txt and sampleoutput3.txt. Then I am trying to join the resultant with sampleoutput2.txt

Code:

#!/bin/bash
awk -F";" 'FNR==NR{A[$2]=$1;next} {print $0 OFS A[$1] OFS}' OFS=";" sampleoutput3.txt sampleoutput1.txt > sampleoutput1-3.txt
awk -F";" 'FNR==NR{B[$1]=$1;next} {print $0 OFS B[$2] OFS B[$3] OFS B[$4]}' OFS=";" sampleoutput2.txt sampleoutput1-3.txt > sampleoutput1-2-3.txt
echo "Output is placed in file : sampleoutput1-2-3.txt"

The file sampleoutput1-3.txt is giving correct output but file : sampleoutput1-2-3.txt is not giving correct output.

Please help.

Thanks
Rahul