awk比较两个文件中多列相同或者不同的行

参考链接

bash comparing multiple column in two files with different length

awk -F, 'NR==FNR{ arr[$2]=$2 $1; next } 
    { print $0, (arr[$2]==$2 $3?"ok":"nok") }' OFS=, def.txt data.txt

d1,40,gold,ok
d2,30,silver,ok
d3,20,bronze,ok
d4,10,iron,ok
d5,5,wood,ok
d6,20,gold,nok
d7,10,wood,nok
d8,5,gold,nok
d9,10,silver,nok

Comparing two columns in two files using awk

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