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