Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 10 Next »

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. 

  • No labels