By the end of this chapter you will be able to:
- Create merge streams
- Configure groupings on pipes
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.
- In the model toolbar, drag the Error rendering macro 'excerpt-include' : No link could be created for '_stream_merge'.onto your model.
- In the settings, set Name:
Customer All Details
. - Click OK to save and close the settings for the
Customer All Details
merge stream. - In the model, hover your mouse pointer over the
CustomerAddresses
stream. - In the pop-up toolbar, select Connector , then click the end of the arrow onto the stream
Customer All Details
. - Similarly, add a pipe from the stream
SOURCE_CUSTOMER_PHONE_NUMBERS
toCustomer All Details
. - Double-click on the pipe from
CustomerAddresses
toCustomer All Details
to open the pipe 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 Show Attributes. PhixFlow displays the list of attributes (columns). Drag
CustomerRef
from the list into the settings. - Close the list of attributes.
- Click Show Attributes. PhixFlow displays the list of attributes (columns). Drag
- In the Basic Settings section, set:
- Double-click on the connector from
CustomerAddresses
to
, this will be calledSOURCE_CUSTOMER_PHONE_NUMBERS
in_2
In the Sort/Group section, press Show Stream Attributes
- From the list that appears, drag
CUSTOMER_REF
into the list - Close the list of attributes
- Now add attributes to the merge stream:
- From the hover menu of
CustomerAddresses
, press Show Stream Attributes - Drag all attributes from this list over the top of
Customer All Details
and "drop" (i.e. release your mouse button)- 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
- Similarly, drag all attributes from
toSOURCE_CUSTOMER_PHONE_NUMBERS
Customer All Details
- To see the resulting configuration in
Customer All Details
, double-click on this stream- In the attributes section, you will see the added attributes
- From the hover menu of
Run Analysis on Stream
Run analysis on your new stream:
- Hover over the stream
Customer All Details
, and press Run Analysis
View Stream data
To view the data you just loaded:
- Hover over the stream and in the hover menu press Show the list of Stream Views
- In the drop down list, select Default View
You will see the address data you loaded from the file combined with the phone numbers you loaded from the database.