...
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:
...