...

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.

1. In the model

...

1. toolbar, drag the 

   Insert excerpt
   _stream_merge _stream_merge nopanel true

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

...

1. .
2. Click

   Insert excerpt
   _finish _finish nopanel true

    to save and close the settings for the Customer All Details merge stream.
3. In the model,

...

1. hover your mouse pointer over the CustomerAddresses stream.
2. 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.
3. Similarly, add a

...

1. pipe from the stream SOURCE_CUSTOMER_PHONE_NUMBERS to Customer All Details.
2. Double-click on the

...

1. pipe from CustomerAddresses  to Customer All Details to open the pipe settings.
   1. In the Basic Settings section,

...

1. 1. set:
      • Name: this pipe is automatically named in.

   2. In the Sort/Group section

...

1. 1. :

      • Click 

        Insert excerpt
        _attributes_show _attributes_show nopanel true

        . PhixFlow displays the list of attributes (columns). Drag CustomerRef from the list into the settings.
      • Close the list of attributes.
2. Double-click on the connector from CustomerAddresses  to SOURCE_CUSTOMER_PHONE_NUMBERS, this will be called in_2

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

   2. From the list that appears, drag CUSTOMER_REF into the list
   3. Close the list of attributes
3. Now add attributes to the merge stream:
   1. From the hover menu of CustomerAddresses, press Image Modified Show Stream Attributes
   2. Drag all attributes from this list over the top of 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
   3. Similarly, drag all attributes from SOURCE_CUSTOMER_PHONE_NUMBERS to Customer All Details
   4. To see the resulting configuration in 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:

...