By the end of this chapter you will be able to:

...

This is because a merge will generate an output record for every key value it finds across all input pipes, whereas if you do a data enrichment using a lookup pipe – you will only get an output record for every record from the input pipe

Filter unmatched rows

To help you find unmatched rows in your output data, you will now add a filter

• Open the data set you have just generated in Channel List Reconciliation 2
• Create a filter:
  
  • Where ANY of the following are true
    
    • SalesCheck equals NO
    • InvCheck equals NO
• Press - Apply the filter without saving
• You will get a list of all non-matched records, that is, all records where the SalesCheck value is NO or the InvCheck value is NO