By the end of this chapter you will be able to:
...
When merging directly from database tables –you have to repeat the ordering of data across the query and the pipe; that is, the ordering of data in the Database Collector query much must match the grouping on the pipe from the Database Collector |
...
- Open the data set you have just generated in Channel List Reconciliation 2
- Press - Select, create or clear a filter
- Press in the drop-down list that appears
- In the filter details form, press the condition at the top of conditions list that says Where ALL of the following are true
- From the drop down list select ANY item true
- The top condition will now say Where ANY of the following are true
- In the second condition in the conditions list:
- Select SalesCheck
- Leave the operator as equals
- In the value field enter: NO
- Add a third condition:
- Select InvCheck
- Leave the operator as equals
- In the value field enter: 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