I have 2 files: File A and File B as below. Field 1 is the key. I am trying to write a sort as below:
1. Record present in File A, not in File B - Need to write to output
2. Record present in File B, not in File A - Need to write to output
3. Record present in File A as well as File B - then writing to output depends on field 3 as below:
i) Field 3 is same - Write File B record.
ii) Field 3 is different - Do not write both.
This is an obvious explanation for why unpaired from first file only. Find where this is defined in your manual, and then find how to create the output you want from the stuff that is similar but gives you the correct output.
The "IF" bit I probably have to leave for the Sort Wizards...