By the end of this chapter you will be able to:
...
...
Table of Contents maxLevel 1 exclude Run analysis*
In this exercise, you will merge the two sets of data you just loaded into PhixFlow: the data from the file, and the data from the database.
Create a merge stream
- In the model toolbar, drag the
onto your model.Insert excerpt _stream_merge _stream_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 pipe connector from the stream
SOURCE_CUSTOMER_PHONE_NUMBERS
toCustomer All Details
.
Configure groupings on the pipes
- Double-click on the pipe from
CustomerAddresses
toCustomer All Details
to open the pipe 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 :
Clickclick
. 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 connector pipe from
CustomerAddresses
to to
, this will be calledSOURCE_CUSTOMER_PHONE_NUMBERS
in_2
In the Sort/Group section, press Show Stream Attributes
From the list that appears, dragCUSTOMER_REF
into the listclick
. 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:- From the hover menu of
CustomerAddresses
, press Show Stream AttributesHover overCustomerAddresses
and in the pop-up toolbar, click
.Insert excerpt _attributes_show _attributes_show nopanel true Drag all attributes from this list
over the top ofand drop them onto the stream icon for
and "drop" (i.e. release your mouse button)Customer All Details
- Note that you can select all attributes by selecting the top attribute, pressing Shift and then selecting the bottom attribute When the dialogue appears, select Use original attribute name
- either click the first attribute then Shift+click the last attribute
- or click the check box next to the Name header.
.
Tip To select all attributes, you can
- From the hover menu of
- PhixFlow asks for confirmation. If it is not already selected, select Use original attribute name. Then click the arrow to confirm.
SOURCE_CUSTOMER_PHONE_NUMBERS
to Customer All Details.
Customer All Details
, double-click on this stream- In the attributes section, you will see the added attributes
Run Analysis on Stream
Run analysis on your new stream:
...
- its icon to open the settings tab and look at the Attributes section. You can see a list of 8 attributes (data columns).
Run analysis and view the stream data
- 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,Insert excerpt _stream_views _stream_views nopanel true
...
- select
. 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