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
Insert excerpt _
...
table_merge _
...
onto your model.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 theInsert excerpt _pipe _pipe nopanel true
...
- table
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
toSOURCE_CUSTOMER_PHONE_NUMBERS
...
- . 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
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
- popup toolbar, click
...
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 Added
- PhixFlow asks for confirmation. If it is not already selected, select Use original attribute name. Then click
...
- Confirm.
- Confirm.
...
- Image Added
- Image Added
- 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
Insert excerpt _
...
view_
...
show _
...
view_
...
. In the drop-down list, selectshow 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