Page Comparison

...

• Open the model Channel Package Check
• Add a new stream to your model from Latest Package All Channels, called Channel List Reconciliation
• Drag all the attributes from Latest Package All Channels into Channel List Reconciliation
• Create a database collector, using the datasource Inventory DB, to read all records from the table SOURCE_ALL_CHANNELS_LIST
• Add a lookup pipe from the database collector SOURCE_ALL_CHANNELS_LIST to the stream Channel List Reconciliation
  • Call the pipe inv
  • Go to the Order/Index section
  • Press Image Removed

    Insert excerpt
    _attributes_show _attributes_show nopanel true

  • Drag the attribute CustomerRef from the left hand box into the list of Order/Index attributes
  • Drag the attribute CustomerRef from the right hand box into the list of Order/Index attributes again – on top of the matching attribute CustomerRef you created above – this will populate the right hand part of the matching attribute
  • Drag Channel from the right hand box into the list of matching attributes
  • Drag Channel from the right hand box into the list of matching attributes again - on top of the matching attribute for Channel that you created above

This lookup will find values in the external database table which match the output records on CustomerRef and Channel

• Press Image Removed in

  Insert excerpt
  _finish _finish nopanel true

   in the main pipe configuration form to save your changes
• Open the configuration form for the stream Channel List Reconciliation
• Add an attribute with Name InvoiceCheck
• In this attribute, you will record whether you returned the channel from the inventory table - to do this, you will count the records returned from the lookup; if this is 1, you will record that the reconciliation check was successful:
  • Set the Expression of the Attribute to:

...