Hi
I have two files t1 and t2.please find the Desc about the files:

T1:

PART_ID1 DESCRIPTION SIZE
1 Seat Cover Large
2 Ash Tray Small
3 Floor Mat Medium

T2:

PART_ID2 COLOR
1 Blue
3 Black
4 Yellow


I would you like output like :

PART_ID DESCRIPTION COLOR
1 Seat Cover Blue
3 Floor Mat Black

Please help me on this join.

awk '{
if(NR==FNR) color[$1]=$2;
else if(color[$1]!="") print $0,color[$1];
}' T2 T1

it's not working....

I tried the script with ur sample input, and it was working. Its not working means is giving any syntax error or its giving wrong result. And the heading is not printed in the script u can add BEGIN in the awk script and print the heading.

Try this....

As you have not specified the record delimiter, I assuming it as comma (,).

awk -F, 'NR==FNR {a[$1]=$2} NR!=FNR {if(a[$1]=="") {next} print $1,$2,a[$1] }' T2 T1

You will get the expected output.

Thanks
Amit