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 view, drag  - Add New Stream (Merge) onto your model pane
• Give this the Name: Customer All Details
• Close the stream details form for Customer All Details
• In the model, from the hover menu of CustomerAddresses select - Add a new Connector, then click the end of the arrow onto the stream Customer All Details
• Similarly, add a connector from the stream SOURCE_CUSTOMER_PHONE_NUMBERS to Customer All Details
• Double click on the connector from CustomerAddresses  to Customer All Details, this will be called in

  • In the Sort/Group section, press - Show Stream Attributes

  • From the list that appears, drag CustomerRef into the list
  • Close the list of attributes
• Double click on the connector from CustomerAddresses  to SOURCE_CUSTOMER_PHONE_NUMBERS, this will be called 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 SOURCE_CUSTOMER_PHONE_NUMBERS to 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

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.