PhixFlow Help
4 Merging Sets of Data
By the end of this chapter you will be able to:
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 Merge Stream  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
. This connector will pipe data into the stream. - Similarly, add a connector from the stream
SOURCE_CUSTOMER_PHONE_NUMBERS
toÂCustomer All Details
.
Configure groupings on the pipes
- 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 Show Attributes. PhixFlow displays the list of attributes (columns).
- 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 pipe will be calledSOURCE_CUSTOMER_PHONE_NUMBERS
in_2.
In the Sort/Group section, click Show Attributes. PhixFlow displays a list of the attributes (columns) in theÂ
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 Show Attributes. Drag all attributes from this list and drop them onto the stream icon forÂ
Customer All Details
.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).
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 Run Analysis. - To view the data you just loaded, hover over the stream and click 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.Â
Please let us know if we could improve this page feedback@phixflow.com