First, i joined the data as shown in the screenshot below.
Then I created a calculated field called [Non PO Code Status]
IF [Category] = 'Non PO' AND ISNULL([Non PO Codes]) THEN 'Non Official'
ELSEIF [Category] = 'Non PO' AND NOT ISNULL([Non PO Codes]) THEN 'Official'
Hope this helps. See attached workbook.
compare_OO.twbx 12.9 KB
I do not understand
- what is the clipboard file and text file you added.
If you can explain that will be very helpful