Hi,

I have two files formatted as following:

File 1: (user_num_ID , realID) (the NR here is 41671)

Code:

1  cust_034_60
2  cust_80_91
3  cust_406_4

..
..

File 2: (realID , clusterNumber) (total NR here is 1000)

Code:

cust_034_60  2
cust_406_4   3
..
..

and i want to compare these two files based on File 1 $2 field and File 2 $1 field and get a resulting file like

File 3: (user_num_ID, realID, clusterNumber)

Code:

1 cust_034_60 2
3 cust_406_4 3
..
..
..

just to summarize:
Create a new file3
Find where file2 ($1) is equal to file1($2)
and print to file3 file1($1) and file2($1,$2) (as a single record)


since im new in awk, i've tried several suggestions from previous threads but it seems that im doing something wrong...

the latest one I've tried:

Code:

awk > file3 'NR==FNR{ _[$2]=$1 next}{print $0, _[$1,$2] }' file1 file2

surely im doing something wrong

Thanks in advance

Moderator's Comments:

Video tutorial on how to use code tags in The UNIX and Linux Forums.