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 maxLevel 1 exclude Run analysis*
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
onto your model.Insert excerpt _table_merge _table_merge nopanel true - In the settings, set Name:
Customer All Details
. - Click
to save and close the settings for theInsert excerpt _finish _finish nopanel true Customer All Details
merge table. - In the model, hover your mouse pointer over the
Customer Addresses
table. - In the popup toolbar, select
, then click the end of the arrow onto the tableInsert excerpt _pipe _pipe nopanel true Customer All Details
. This connector will pipe data into the table. - Similarly, add a connector from the table
SOURCE_CUSTOMER_PHONE_NUMBERS
toCustomer All Details
.
Configure groupings on the pipes
- Double-click on the pipe from
Customer Addresses
toCustomer All Details
to open its settings.- In the Basic Settings section, set:
- Name: this pipe is automatically named
in
.
- Name: this pipe is automatically named
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. - Close the list of attributes.
- In the Basic Settings section, set:
- Double-click on the pipe from
CustomerAddresses
to
. This pipe will be calledSOURCE_CUSTOMER_PHONE_NUMBERS
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
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
.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
.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
- Similarly, drag all attributes from
toSOURCE_CUSTOMER_PHONE_NUMBERS
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
.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
. You will see the address data you loaded from the file combined with the phone numbers you loaded from the database.Insert excerpt _view_default _view_default nopanel true