Search Results

The solution didn't work. The second file xyz.txt is a master file and multiple records from abc.txt match at least one record from xyz.txt

Here are two sample files

abc.txt

name fff1 ppp1
sam 1 12
pam 1 14
jen 2 8
trout 2 6
pat 3 12
don 3 16


xyz.txt

id fff1 qqq1 rrr1
234 ...

I have a problem joining two files. The first file abc.txt has 10k lines and has lots of fields but two fields fff1 and ppp1 to merge by. The second file xyz.txt is a master file with 1k lines and...