...
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
CustomerAddressesselect
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_NUMBERStoCustomer All Details - Double click on the connector from
CustomerAddressestoCustomer All Details, this will be calledinIn the Sort/Group section, press
- From the list that appears, drag
CustomerRefinto the list - Close the list of attributes
- Double click on the connector from
CustomerAddressestoSOURCE_CUSTOMER_PHONE_NUMBERSin_2In the Sort/Group section, press
- Show - From the list that appears, drag
CUSTOMER_REFinto the list - Close the list of attributes
- Now add attributes to the merge stream:
- From the hover menu of
CustomerAddresses, press - Show - Drag all attributes from this list over the top of
Customer All Detailsand "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_NUMBERSCustomer 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
- From the hover menu of
...
- Hover over the stream
Customer All Details, and press
Run Analysis
View Stream data
...
- Hover over the stream and in the hover menu press
- 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.