This question already has an answer here:
I have two pipe delimited files as below
TEST|123456 TEST|123457 TEST|123458 TEST|123459 TEST|123460
TEST|123456|RAY|DOE|| TEST|123457|JANE|DOE|| TEST|123458|ROSE|DAWN|| TEST|123459|GEORGE|BRID|| TEST|123460|RALPH|DOE|| TEST|123461|JOHN|DOE|| TEST|123462|STEVE|SMITH||
File 3 - Desired Output
I want to use the first and second column of file1 and file2 as key to getting the unmatched rows from file 2.