Compare selected columns of two files and print whole line with mismatch

Shell Programming and Scripting
1

hi! i researched about comparing two columns here and got an answer. but after examining my two files, i found out that the first columns of the two files are not unique with each other. all i want to compare is the 2nd and 3rd column.

FILE 1:
ABS 456 315
EBS 923 163
JYQ3 654 237

FILE 2:
ABS 456 315
JYQ 654 273

OUTPUT FILE:

FROM FILE1:
EBS 923 163
JYQ3 654 237

FROM FILE 2:
JYQ 654 273
2

If I'm guessing right (you will loose the original order):

awk 'END {
  for (key in count) 
    if (count[key] == 1)
      print rec[key]
  }
{ 
  count[$2, $3]++
  rec[$2, $3] = $0
  }' file1 file2
1 Like