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

1. In the model toolbar, drag the 

   Insert excerpt
   _stream_merge _stream_merge nopanel true

     onto your model.
2. In the settings, set Name: Customer All Details.
3. Click

   Insert excerpt
   _finish _finish nopanel true

    to save and close the settings for the Customer All Details merge stream.
4. In the model, hover your mouse pointer over the CustomerAddresses stream.
5. In the pop-up toolbar, select 

   Insert excerpt
   _pipe _pipe nopanel true

   , then click the end of the arrow onto the stream Customer All Details. This connector will pipe data into the stream.
6. Similarly, add a pipe connector  from the stream SOURCE_CUSTOMER_PHONE_NUMBERS to Customer All Details.

Configure groupings on the pipes

1. Double-click on the pipe from CustomerAddresses  to Customer All Details to open the pipe its settings.
   1. In the Basic Settings section, set:
      • Name: this pipe is automatically named in.

   2. In the Sort/Group section :click 

      Click 

      Insert excerpt
      _attributes_show _attributes_show nopanel true

      . PhixFlow displays the list of attributes (columns).

   3. Drag CustomerRef from the list into the settings.
   4. Close the list of attributes.
2. Double-click on the connector pipe from CustomerAddresses  to  to SOURCE_CUSTOMER_PHONE_NUMBERS, this will be called in_2

   1. In the Sort/Group section, press Image Removed Show Stream Attributes

      From the list that appears, drag CUSTOMER_REF into the list

      click 

      Insert excerpt
      _attributes_show _attributes_show nopanel true

      . PhixFlow displays a list of the attributes (columns) in the CustomerAddresses  data.

   2. Drag CUSTOMER_REF into the Sort/Group section.
   3. Close the list of attributes.
3. Now add attributes from CustomerAddresses to the merge stream:
   1. From the hover menu of CustomerAddresses, press Image Removed Show Stream AttributesHover over CustomerAddresses and in the pop-up toolbar, click 

      Insert excerpt
      _attributes_show _attributes_show nopanel true

      .

   2. Drag all attributes from this list

      over the top of

      and drop them onto the stream icon for Customer All Details

      and "drop" (i.e. release your mouse button)
      1. Note that you can select all attributes by selecting the top attribute, pressing Shift and then selecting the bottom attribute
      2. When the dialogue appears, select Use original attribute name

      .

      Tip
      title 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.  Image Added

      
      

   3. PhixFlow asks for confirmation. If it is not already selected, select Use original attribute name. Then click the arrow Image Added to confirm.
      Image Added
      
4. Similarly, drag all attributes from SOURCE_CUSTOMER_PHONE_NUMBERS to Customer All Details.
5. To see the resulting configuration in settings for Customer All Details, double-click on this stream
   1. In the attributes section, you will see the added attributes

Run Analysis on Stream

Run analysis on your new stream:

...

1. 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

1. To run analysis on your new stream, hover your mouse pointer over the stream Customer All Details, and

...

1. in the pop-up toolbar, click 

   Insert excerpt
   _run_analysis _run_analysis nopanel true

   .
2. To view the data you just loaded

...

1. , hover over the stream and

...

1. click 

   Insert excerpt
   _stream_views _stream_views nopanel true

   . In the drop-down list,

...

1.  select

   Insert excerpt
   _view_default _view_default nopanel true

   . You will see the address data you loaded from the file combined with the phone numbers you loaded from the database.