...
So far your model has merged data from two files, then grouped and sorted the records. You now have a stream that has the latest data about the TV package that each customer has.
We You now want to get a set of records for each channel that the customer has ordered. In this section you are going to add information about which channels are included for each package. This data is currently in a database table. PhixFlow can look-up this data. To make sure that PhixFlow finds all the channels, you will use an ouptut multiplier
...
An output multiplier tells PhixFlow to process the same record multiple times, each time producing a new record. This is called "breaking-out" a record. In this case we want PhixFlow to keep processing the same customer record until it has found all the channels. This means our single input record for each customer becomes multiple output records, like this:
...
- which pipe it will use -
find_channels
pipe. - what data you want to add - the channels.
The stream also needs to know about the new column to create for the channel information.
- In the model, double-click
Latest Package All Channels
to open its settings tab. - To create the output multiplier, expand the Multipliers and Filters section and set:
- Output Multiplier:
find_channels.CHANNEL
- Output Multiplier:
- To create a new column for the channel data, expand the Attributes section. Click
to add a new attribute. PhixFlow opens a new attribute settings tab. Set:Insert excerpt _add_object _add_object nopanel true - Name:
Channel
- Expression:
_outputMultiplier
- Name:
- Click
to save and close the settings tab.Insert excerpt _fini _fini nopanel true - In the model toolbar, click
to save your model.Insert excerpt _save _save nopanel true
...
You can run the model and view the stream data.
Expand title How? - Hover your mouse pointer over the
Latest Package All Channels
stream and click
then click YES to confirm.Insert excerpt _run_analysis _run_analysis nopanel true - When PhixFlow notifies you that the analysis is finished, hover your mouse pointer over the
Latest Package All Channels
stream again. - Click
.Insert excerpt _show_stream_views _show_stream_views nopanel true - In the drop-down list, select
. PhixFlow displays the data.Insert excerpt _default_view _default_view nopanel true
- Hover your mouse pointer over the
Troubleshooting: What do I do if there is no data.Something might have gone wrong with something