...

1. Create a new stream in your model and populate its attributes.
   1. Hover over CustomerCareUpdates and click  Add a new Stream.
   2. In the properties, set the Name to  Combined Updates.
   3. In the model, show the stream attributes for CustomerCareUpdates .
   4. Select all the attributes and drag them into the properties for the Combined Updates stream. Drop them into the Attributes section.
2. Save your model layout.
3. Connect the ShopUpdates stream to the Combined Updates stream.
   1. Hover over ShopUpdates and click  Add a new Connector.

   2. Click Combined Updates to link the pipe to the stream.

      Info
      When you connect streams, PhixFlow automatically adds a reference to the input pipe name. this appears in the attribute expression. To merge this data successfully you must update the attribute expressions to remove the in. prefix.

      
      

4. Fix all the attribute expressions.
   1. Double-click on Combined Updates to open its properties. For  each attribute:
   2. In the Attributes section, double-click on an attribute to open its properties.
   3. In the properties for the attribute, in the Basic Settings section, edit the Expression to remove in. and press .
      
5. In the Combined Updates stream properties, press Image Removed to save the changes.Run analysis settings tab, click 

   Insert excerpt
   _finish _finish nopanel true

    to save and close.
6. Click 

   Insert excerpt
   _run_analysis _run_analysis nopanel true

   on Combined Updates.
7. Check that the stream has:
   • the columns CustomerRef, Sales Date and Package
   • 15 rows
   • all cells have data.
     The stream default view:
     

Snapshot of the Chanel Package Check model so far:

Image Modified

Record the source for each update

You will now update your configuration settings to record the source for each update, in the set of combined updates. To do this:

1. Update the name of the pipe from the stream CustomerCareUpdates.
   1. Double-click on the pipe to open its properties.
   2. Update the Name to CC.Press Image Removed to save your changes.
   3. Click 

      Insert excerpt
      _finish _finish nopanel true

       to save and close the settings tab
2. Update the name of the pipe from ShopUpdates to shop.
3. Double-click the stream Combined Updates to open its properties.
4. In the Attributes section, add a new attribute and set:
   1.  Name: Source.

   2. Expression :

      Code Block
      if (_pipeName == "CC", "Customer Care" , "Shop" )

      
      

5. To make Source the first attribute in the stream, drag it to the top of the attributes list.Press Image Removed in the main stream properties
6. Click 

   Insert excerpt
   _finish _finish nopanel true

    in the main stream settings tab.
7. Run analysis on Combined Updates.
8. Check the output data set and make sure that the source has been recorded on each record correctly.