Thanks for your quick reply .
There is a answer to your question :
"Do you want a single "another file", or one file for each secondary"

Yes. I want to create a single output file and also want to know which
secondary the mismatched row came from?


Following will be my output

Secondary1.txt|Currency_exchange|21000
Secondary2.txt|Currency_exchange|23100