...
- Open the model
Channel Package Check
- Add a new stream to your model from
Latest Package All Channels
, calledChannel List Reconciliation
- Drag all the attributes from
Latest Package All Channels
intoChannel List Reconciliation
- Create a database collector, using the datasource
Inventory DB
, to read all records from the tableSOURCE_ALL_CHANNELS_LIST
- Add a lookup pipe from the database collector
SOURCE_ALL_CHANNELS_LIST
to the streamChannel List Reconciliation
- Call the pipe
inv
- Go to the Order/Index section
- Press
- Drag the attribute
CustomerRef
from the right left hand box into the list of matching Order/Index attributes - Drag the attribute
CustomerRef
from the right hand box into the list of matching Order/Index attributes again – on top of the matching attributeCustomerRef
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 forChannel
that you created above
- Call the pipe
...