Versions Compared
compared with
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Insert excerpt | ||||||||
---|---|---|---|---|---|---|---|---|
|
By the end of this chapter you will be able to:
Table of Contents | ||||
---|---|---|---|---|
|
Create a merge table
You will now add a
merge streamIn the model toolbar, dragnew merge table to your Introduction to Modelling analysis model to merge the two sets of data.
Hover your mouse over
s in the toolbar to show the list of options.Insert excerpt _tables _tables nopanel true
- Drag the
onto onto your model.Insert excerpt _table_merge _table_merge nopanel true - In the settings Basic Settings, set Name:
Customer All Details
. - Click
to save and close the settings for the Customer the Customer All Details merge table.Insert excerpt _finish _finish nopanel true - In the model, hover your mouse pointer over the Customer Addresses table you created earlier.
- In the popup toolbar, select
, then click the end of the arrow onto the table Customer All Details. This connector will pipe data into the merge table.Insert excerpt _pipe _pipe nopanel true - Similarly, add a connector from the table SOURCE_CUSTOMER_PHONE_NUMBERS to to Customer All Details.
Configure groupings on the pipes
- Double-click on the pipe from Customer Addresses to 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
. PhixFlow displays the list of attributes (columns).Insert excerpt _attributes_show _attributes_show nopanel true - Drag CustomerRef from the list into the settings Sort/Group section.
- Close the list of attributes.
- In the settings, click
.Insert excerpt _save _save nopanel true
- In the Basic Settings section, set:
- Double-click on the pipe from
CustomerAddresses
to SOURCE_CUSTOMER_PHONE_NUMBERS to Customer All Details. This pipe will be called in_2.
In the Sort/Group section, click
. PhixFlow displays a list of the attributes (columns) in theInsert excerpt _attributes_show _attributes_show nopanel true Customer Addresses
dataSOURCE_CUSTOMER_PHONE_NUMBERS data.- Drag CUSTOMER_REF into into the Sort/Group section.
- Close the list of attributes.
- In the settings, click
.Insert excerpt _save _save nopanel true
- Now add attributes from Customer Addresses Addresses
- Hover over Customer Addresses Addresses
.Insert excerpt _attributes_show _attributes_show nopanel true Drag all attributes from this list and drop them onto the table icon for Customer All Details in your model.
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 RemovedImage Added
- PhixFlow asks for confirmation. If it is not already selected, select Use original attribute name. Then click the arrow Image Removed to confirmConfirm.
Image RemovedImage Added
- Hover over Customer Addresses Addresses
- Similarly, drag all attributes from SOURCE_CUSTOMER_PHONE_NUMBERS to 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
streamtable data
- To run analysis on your new table, hover your mouse pointer over the stream table Customer All Details, and in the popup toolbar, click
.Insert excerpt _run_analysis _run_analysis nopanel true - To view the data you just loaded, hover over the table and click
. In the drop-down list, selectInsert excerpt _view_show _view_show nopanel true Insert excerpt _view_default _view_default . You You will see the address data you loaded from the file combined with the phone numbers you loaded from the database. , like the image below:nopanel true - Image Added
- Click
to finish and close the merge table settings.Insert excerpt _finish _finish nopanel true - In the model window, click
.Insert excerpt _save_saveModel _save_saveModel nopanel true
Check Point
At this point your screen should look like this:
Image Added