Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: DOC-74 more updates

...

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.

  1. In the model, double-click Latest Package All Channels to open its settings tab.
  2. To create the output multiplier, expand the Multipliers and Filters section and set:
    • Output Multiplier: find_channels.CHANNEL
  3. To create a new column for the channel data, expand the Attributes section. Click 
    Insert excerpt
    _add_object
    _add_object
    nopaneltrue
     to add a new attribute. PhixFlow opens a new attribute settings tab. Set:
    •  Name: Channel
    •  Expression: _outputMultiplier
  4. Click 
    Insert excerpt
    _fini
    _fini
    nopaneltrue
     to save and close the settings tab.
  5. In the model toolbar, click 
    Insert excerpt
    _save
    _save
    nopaneltrue
     to save your model.

...

  1. You can run the model and view the stream data.

    Expand
    titleHow?
    1. Hover your mouse pointer over the Latest Package All Channels stream and click 
      Insert excerpt
      _run_analysis
      _run_analysis
      nopaneltrue
       then click YES to confirm.
    2. When PhixFlow notifies you that the analysis is finished, hover your mouse pointer over the Latest Package All Channels stream again.
    3. Click 
      Insert excerpt
      _show_stream_views
      _show_stream_views
      nopaneltrue
      .
    4. In the drop-down list, select 
      Insert excerpt
      _default_view
      _default_view
      nopaneltrue
      .  PhixFlow displays the data.


Troubleshooting: What do I do if there is no data.Something might have gone wrong with something