...
- Create a new stream in your model and populate its attributes.
- Hover over
CustomerCareUpdates
and clickInsert excerpt _add_stream _add_stream nopanel true - In the settings, set the Name to
Combined Updates
. - In the model, show the stream attributes for
CustomerCareUpdates
. - Select all the attributes and drag them into the properties for the
Combined Updates
stream. Drop them into the Attributes section. - Click
.Insert excerpt _finish _finish nopanel true
- Hover over
- To save your model, in the model toolbar click
.Insert excerpt _save _save nopanel true - Connect the
ShopUpdates
stream to theCombined Updates
stream.- Hover over
ShopUpdates
and click
.Insert excerpt _add_connector _add_connector nopanel true Click
Combined Updates
to link the pipe to the stream.Info When you connect streams, PhixFlow automatically adds a reference to the input pipe name. This appears in the attribute expression. To merge this data successfully, you must update the attribute expressions to remove the
in.
prefix; see step 4 below.
- Hover over
- Fix all the attribute expressions.
- Double-click on
Combined Updates
to open its settings tab. For each attribute: - In the Attributes section, double-click on an attribute to open its settings.I
- In the Basic Settings section, edit the Expression to remove
in.
and clickInsert excerpt _finish _finish nopanel true
- Double-click on
- In the
Combined Updates
stream settings tab, click
to save and close.Insert excerpt _finish _finish nopanel true - In the model, hover your mouse pointer over
Combined Updates
and click
.Insert excerpt _run_analysis _run_analysis nopanel true - When the stream has run, check that the stream has:
- the columns CustomerRef, Sales Date and Package
- 15 rows
- all cells have data.
The stream default view:
...