Shell Programming and Scripting

I searched a lot considering this theme,but still cant make my code working.
I have two tab separated files, I want to do the following thing:

File 1:

Code:

xx1 y yy
xx2 y yy
xx3 y yy
xx4 y yy

File 2:

Code:

xx1 z1
xx2 z2
xx3 z3
xx4 z4
xx5 z5

So I want to merge them ,according to the first column and receive:

File 3:

Code:

xx1 y yy z1
xx2 y yy z2
xx3 y yy z3
xx4 y yy z4

nawk with while and getline doesnt work at all, so I tried to write smth with NR,FNR

Code:

 
NR==FNR{a[$1]=$2;next}
{($1 in a) print $1,$4,a[$3]}' file1 file2

the problem is that after {a[$1]=$0 ; next} it doesnt see this array anymore.So after next and } i can not print it and do anything else with it .

I tried to write code like this:

Code:

awk '
NR==FNR{a[$1]=$2;next}
a[$3]{print $1,$4,a[$3]}' file1 file2

but still experienced same problem


Thank you for any help!

have you tried using join...?

Code:

join file1 file2

and with awk

Code:

awk 'FNR==NR{a[$1]=$0;next}{if(a[$1]){print a[$1],$2}}' file1 file2

I was thinking about this ,but will it be working if I have different amount of rows in files?

As per your requirement it should work.

Try with awk also i have give in previous script..

Thanks for your reply!
I tried to use awk,but it still doesnt give me any output ,but these files definitely have compatible rows.
Could you please describe me how can I use join command?

As per your given input awk and join are working fine..
Or give some more input. And for awk have you tried with nawk...?

You can use join. Go through man pages of join

Join normally works as to join files. It joins files field by field. You can change the pattern how to join the files. You can get more details in Man pages.

Hope this helps you.

I sorted files and then used join -1 1 -2 1 file1 fil2 but it gives me zero output
I tried the following code:

Code:

nawk -F\t 'NR==FNR{a[$1]=$0;next} ($1 in a) 'file1 file2

it works almost well,but it doesnt give me the value of the column according to which Im sorting
So it gives the following result
file 1:

Code:

xx1 y1 y2
xx2 y1 y2
xx3  y1 y2

file 2

Code:

xx1 z1 
xx2 z2
xx3 z3 
xx4 z4
xx5 z5

and as output Im receiving

Code:

z1 z2 z3

and I cant figure out how to make it printing at least the first column
its strange that if I add if statement it doesnt see array values anymore