...
This lookup will find values in the external database table which match the output records on CustomerRef and Channel
- Press Press
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