参考サイト a.tsv
1 2 3 4 5 |
c 7 r z d 6 s w f 1 f f b 8 p y a 9 q x |
b.tsv
1 2 3 4 5 |
a q a c r ccc b p bb 0 0 0 d s dddd |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
awk ' BEGIN {FS=OFS="\t"} NR==FNR { key = $1 FS $3 if (key in a) a[key] = a[key] "\n" $2 FS $4 else a[key] = $2 FS $4 next } $1 FS $2 in a { split(a[$1 FS $2], ary, /\n/) for (idx in ary) print ary[idx], $3 } ' a.tsv b.tsv |