Page Comparison

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

...

• Add a new merge stream to your model, by dragging in the icon  onto your model pane.
• Call this stream Name Channel List Reconciliation 2
• Add an input pipe from Latest Package All Channels, with Name sales
• Drag the following attributes from Latest Package All Channels to Channel List Reconciliation 2:
  • CustomerRef
  • Channel
• Add an pipe from the database collector SOURCE_ALL_CHANNELS_LIST to Channel List Reconciliation 2

  • Call this pipe inv

  • Set up the grouping attributes on the input pipes:
    • Double click on the pipe sales
      • Go to the Sort/Group section
      • Press  and drag in CustomerRef and Channel
      • Press  to save your changes
    • Double-click on the pipe inv
      • Go to the Sort/Group section
      • Press 
      • In the new grouping attribute form that pops up:
        • Select the attribute CustomerRef from the drop down list
        • Tick the Group flag
        • Press 
      • Add the grouping attribute Channel in the same way
      • Back in the main pipe configuration form, press 

...

select * from SOURCE_ALL_CHANNELS_LIST
 order by CustomerRef, Channel
 

(the

...

ordering

...

is

...

needed

...

to

...

support

...

the

...

merge)

...

• 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