...
- In the model toolbar, drag the
onto your model.Insert excerpt _streamtable_merge _streamtable_merge nopanel true - In the settings, set Name:
Customer All Details
. - Click
to save and close the settings for theInsert excerpt _finish _finish nopanel true Customer All Details
merge stream. - In the model, hover your mouse pointer over the
CustomerAddresses
stream. - In the pop-up toolbar, select
, then click the end of the arrow onto the streamInsert excerpt _pipe _pipe nopanel true Customer All Details
. This connector will pipe data into the stream. - Similarly, add a connector from the stream
SOURCE_CUSTOMER_PHONE_NUMBERS
toCustomer All Details
.
...
- Double-click on the pipe from
CustomerAddresses
toCustomer All Details
to open its settings.- In the Basic Settings section, set:
- Name: this pipe is automatically named
in
.
- Name: this pipe is automatically named
In the Sort/Group section click
. PhixFlow displays the list of attributes (columns).Insert excerpt _attributes_show _attributes_show nopanel true - Drag
CustomerRef
from the list into the settings. - Close the list of attributes.
- In the Basic Settings section, set:
- Double-click on the pipe from
CustomerAddresses
to
, this . This pipe will be calledSOURCE_CUSTOMER_PHONE_NUMBERS
in_2.
In the Sort/Group section, click
. PhixFlow displays a list of the attributes (columns) in theInsert excerpt _attributes_show _attributes_show nopanel true CustomerAddresses
data.- Drag
CUSTOMER_REF
into the Sort/Group section. - Close the list of attributes.
- Now add attributes from
CustomerAddresses
to the merge stream:- Hover over
CustomerAddresses
and in the pop-up toolbar, click
.Insert excerpt _attributes_show _attributes_show nopanel true Drag all attributes from this list and drop them onto the stream icon for
Customer All Details
.Tip title How to select all the attributes in a list To select all attributes, you can:
- either click the first attribute then Shift+click the last attribute
- or click the check box next to the Name header.
- PhixFlow asks for confirmation. If it is not already selected, select Use original attribute name. Then click the arrow to confirm.
- Hover over
- Similarly, drag all attributes from
toSOURCE_CUSTOMER_PHONE_NUMBERS
Customer All Details.
- To see the resulting settings for
Customer All Details
, double-click its icon to open the settings tab and look at the Attributes section. You can see a list of 8 attributes (data columns).
...
- To run analysis on your new stream, hover your mouse pointer over the stream
Customer All Details
, and in the pop-up toolbar, click
.Insert excerpt _run_analysis _run_analysis nopanel true - To view the data you just loaded, hover over the stream and click
. In the drop-down list, selectInsert excerpt _streamview_viewsshow _streamview_viewsshow nopanel true
. You will see the address data you loaded from the file combined with the phone numbers you loaded from the database.Insert excerpt _view_default _view_default nopanel true