Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Table of Contents

You will also learn how to pass only some records to the receiving stream using the Maximum Number of Records per Group option.

In this exercise you will select the most recent sales record for each customer from the set of combined updates you created in the previous exercise.

...

In PhixFlow, we use an aggregate stream to show that we are rearranging data from a single stream. See the reference page Aggregate Stream for Aggregating Data for details.

  1. From the model toolbar, drag 
    Insert excerpt
    _table_aggregate
    _table_aggregate
    nopaneltrue
     into the model.
  2. Set the stream Name to Latest Package Update.
  3. Add a pipe from Combined Updates:
    1. Hover your mouse pointer over the stream Combined Updates.
    2. In the context toolbar, click 
      Insert excerpt
      _pipe
      _pipe
      nopaneltrue
      .
    3. Click the stream Latest Package Update to connect the pipe.
    4. PhixFlow opens the pipe settings. Click 
      Insert excerpt
      _finish
      _finish
      nopaneltrue
       to close the settings.
  4. Drag all attributes from Combined Updates to Latest Package Update.
    1. Make sure the open settings form is for the stream Latest Package Update.
    2. Hover your mouse pointer over the stream Combined Updates.
    3. In the context toolbar, click 
      Insert excerpt
      _attributes
      _attributes
      nopaneltrue
      . Phixflow lists the data attributes (column titles) for this stream.
    4. Select all the attributes and drag them into the Latest Package Update settings → Attributes section.
    5. Click 
      Insert excerpt
      _finish
      _finish
      nopaneltrue
       to save and close the Latest Package Updates settings.
    6. Close the attributes pop-up window.
  5. In the Channel Package model toolbar, click 
    Insert excerpt
    _save
    _save
    nopaneltrue
    .

...