Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
_Banners
_Banners
nameanalysis
nopaneltrue

By the end of this chapter you will be able to:

Table of Contents
maxLevel1
excludeRun 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

You will now add a new merge table to Introduction to Modelling analysis model to merge the two sets of data.

  1. Hover your mouse over 

    Insert excerpt
    _tables
    _tables
    nopaneltrue
    s in the toolbar to show the list of options.

  1. Drag the 
    Insert excerpt
    _table_merge
    _table_merge
    nopaneltrue
     onto your model.
  2. In the Basic Settings, set Name: Customer All Details.
  3. Click
    Insert excerpt
    _finish
    _finish
    nopaneltrue
     to save and close the settings for the Customer All Details merge table.
  4. In the model, hover your mouse pointer over the Customer Addresses table you created earlier.
  5. In the popup toolbar, select 
    Insert excerpt
    _pipe
    _pipe
    nopaneltrue
    , then click the end of the arrow onto the table Customer All Details. This connector will pipe data into the merge table.
  6. Similarly, add a connector from the table SOURCE_CUSTOMER_PHONE_NUMBERS to Customer All Details.

Configure groupings on the pipes

  1. Double-click on the pipe from Customer Addresses to Customer All Details to open its settings.
    1. In the Basic Settings section, set:
      • Name: this pipe is automatically named in.
    2. In the Sort/Group section, click 

      Insert excerpt
      _attributes_show
      _attributes_show
      nopaneltrue
      . PhixFlow displays the list of attributes (columns).

    3. Drag CustomerRef from the list into the settings.
    4. Close the list of attributes.
    5. In the settings, click 
      Insert excerpt
      _save
      _save
      nopaneltrue
      .
  2. Double-click on the pipe from SOURCE_CUSTOMER_PHONE_NUMBERS to Customer All Details. This pipe will be called in_2.
    1. In the Sort/Group section, click 

      Insert excerpt
      _attributes_show
      _attributes_show
      nopaneltrue
      . PhixFlow displays a list of the attributes (columns) in the SOURCE_CUSTOMER_PHONE_NUMBERS data.

    2. Drag CUSTOMER_REF into the Sort/Group section.
    3. Close the list of attributes.
    4. In the settings, click 
      Insert excerpt
      _save
      _save
      nopaneltrue
      .
  3. Now add attributes from Customer Addresses to the merge table:
    1. Hover over Customer Addresses and in the popup toolbar, click 
      Insert excerpt
      _attributes_show
      _attributes_show
      nopaneltrue
      .
    2. Drag all attributes from this list and drop them onto the table icon for Customer All Details in your model.

      Tip
      titleHow 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


    3. PhixFlow asks for confirmation. If it is not already selected, select Use original attribute name. Then click Confirm.

  4. Similarly, drag all attributes from SOURCE_CUSTOMER_PHONE_NUMBERS to Customer All Details.
  5. 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

  1. 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
    nopaneltrue
    .
  2. To view the data you just loaded, hover over the table and click 
    Insert excerpt
    _view_show
    _view_show
    nopaneltrue
    . 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:
    1. Image RemovedImage Added
  3. Click 
    Insert excerpt
    _finish
    _finish
    nopaneltrue
     to finish and close the merge table settings
  4. In the model window, click 
    Insert excerpt
    _save_saveModel
    _save_saveModel
    nopaneltrue
    .

Check Point

At this point your screen should look like this: