Search Results

To work correctly, both files being joined need to be sorted on the fields that are to be used as the matching fields. Since File 1 has the values in the order
P
S
Cinstead of
C
P
Sfor the...

Assuming that you saved the above awk script in a file (say satya.awk for purposes of this discussion), and then ran the command:
awk -f satya.awk File1then it might or might now work since setting...

try:
awk '
! a[$1] {a[$1]=$1}
{ for (i=2; i<=NF; i++) a[$1]=a[$1] OFS $i; }
END {for (i in a) print a[i]}
' File1 File2