...

• Create a database collector, using the datasource Rating and Billing, to read all the records from this table
• Create a stream from this database collector
• Run analysis on the stream

Create

...

a stream for full channel list

1. Add a new stream to your model to hold the full channel list:
   1. Create a stream using the Add a new Stream button in the hover menu from Latest Package Update
   2. Give the new Stream the Name Latest Package All Channels
2. Drag all attributes from Latest Package Update to Latest Package All Channels
3. To complete the configuration:
4. Add a lookup pipe from SOURCE_PACKAGE_CHANNELS into Latest Package All Channels
5. Call the pipe chan
6. Go to the Order/Index section
7. Press Image Modified - Show Stream Attributes
8. Drag PACKAGE from the left hand (input) list
9. Drag Package from the right hand (output) list over the top of the Order/Index attribute PACKAGE
10. Double click on the Order/Index attribute PACKAGE to edit its details:
11. Update the Index Expression from _out.Package to: in.Package
12. Save your changes

This means that the lookup will match records in the reference data (SOURCE_PACKAGE_CHANNELS) where PACKAGE = Package from the input pipe in
We must do this, rather than using the value of Package from the output because we are using the lookup to drive an output multiplier – and output multipliers are calculated before the output is generated

...