By the end of this chapter you will be able to:

• Use an output multiplier to break out a record into multiple output records

In this exercise you will load reference data into your model which lists all the TV channels offered in each package. You will use this to break out each customer record, in Latest Package Update, into a set of records for each channel that the customer has ordered.

Load reference data

The database table SOURCE_PACKAGE_CHANNELS gives the list of channels available in each package.

• 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  - 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

• Open the configuration form for the stream Latest Package All Channels by double clicking it
• In the field Output Multiplier, enter the value: chan.CHANNEL

This means that for each output record processed, PhixFlow will look up the list of channels for the package from the reference stream; it will then work through the list returned, handling each element from the list in turn and generating an output record in the stream for each one

• Add an attribute to the stream with Name Channel
• Set the Expression of this attribute to _outputMultiplier

This will print the value of the current element of the output multiplier list to this field

• Save your changes
• Run analysis on the stream Latest Package All Channels
• Check that your output is a full list of all channels for each customer