Capture Only Not matching rows
Posted: Mon Mar 03, 2014 12:27 pm
Hi,
I have an input with a key and another table with error records. I have to match my input with the table and get only the non matching records. Currently I have a lookup, output and reject. But, since I don't want any matched records for further processing, I want to avoid writing these matched recors into a file. Is there any way I can capture only the Non Matching records from look up?
Input 1: File
Lookup: Table
Output: Only non matched records
Thanks in advance,
Yugee.
I have an input with a key and another table with error records. I have to match my input with the table and get only the non matching records. Currently I have a lookup, output and reject. But, since I don't want any matched records for further processing, I want to avoid writing these matched recors into a file. Is there any way I can capture only the Non Matching records from look up?
Input 1: File
Lookup: Table
Output: Only non matched records
Thanks in advance,
Yugee.