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 table
In the model toolbar, drag the Merge Table onto your model.
In the settings, set Name: Customer All Details.
Click Apply and Close to save and close the settings for the Customer All Details merge table.
In the model, hover your mouse pointer over the Customer Addresses table.
In the popup toolbar, select Connector, then click the end of the arrow onto the table Customer All Details. This connector will pipe data into the table.
Similarly, add a connector from the table SOURCE_CUSTOMER_PHONE_NUMBERS to Customer All Details.
Configure groupings on the pipes
Double-click on the pipe from Customer Addresses to Customer All Details to open its settings.
In the Basic Settings section, set:
Name: this pipe is automatically named in.
In the Sort/Group section click Show Attributes. PhixFlow displays the list of attributes (columns).
Drag CustomerRef from the list into the settings.
Close the list of attributes.
Double-click on the pipe from CustomerAddresses to SOURCE_CUSTOMER_PHONE_NUMBERS. This pipe will be called in_2.
In the Sort/Group section, click Show Attributes. PhixFlow displays a list of the attributes (columns) in the Customer Addresses data.
Drag CUSTOMER_REF into the Sort/Group section.
Close the list of attributes.
Now add attributes from Customer Addresses to the merge table:
Hover over Customer Addresses and in the popup toolbar, click Show Attributes.
Drag all attributes from this list and drop them onto the table icon for Customer All Details.
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.
PhixFlow asks for confirmation. If it is not already selected, select Use original attribute name. Then click the arrow to confirm.
Similarly, drag all attributes from SOURCE_CUSTOMER_PHONE_NUMBERS to Customer All Details.
To see the resulting settings for Customer All Details, double-click 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 table data
To run analysis on your new table, hover your mouse pointer over the table Customer All Details, and in the popup toolbar, click Run Analysis.
To view the data you just loaded, hover over the table and click Show view. 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.