Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

  • Press Press Image Modified 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:
Code Block
if (countElements(inv) == 1,

...


 "YES"

...


 ,

...


 "NO"

...


 )
  • Save your changes to the Stream
  • Run Analysis on Channel List Reconciliation
  • Review the results, and see which channels reconciled against the list from the inventory database, and which did not
    • Remember that you can open the data in the external inventory table using the CenterView PhixFlow schema browser – if you want to verify the results