Versions Compared

Key

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

...

  1. In your model, hover your mouse pointer over the 
    Insert excerpt
    _datasource
    _datasource
    nopaneltrue
     icon. In the pop-up popup toolbar, click  
    Insert excerpt
    _table_database
    _table_database
    nopaneltrue
  2. In the list of tables that PhixFlow opens, scroll down to the SOURCE_CUSTOMER_PHONE_NUMBERS table name.
    1. To have a look at the data in this table, double-click its name.
    2. You can see there are columns for ##CUSTOMER_REF and ##PHONE_NUMBER.
    3. Close this data form
  3. Right-click SOURCE_CUSTOMER_PHONE_NUMBERS and in the pop-up popup menu, select Create a Collector. PhixFlow adds a new database collector  to your model, which reads data from the table SOURCE_CUSTOMER_PHONE_NUMBERS.
  4. Double-click on the new database collector to open its settings.
  5. In the Basic Settings section → Statement Expression field, you can see that PhixFlow has added a database query.
  6. Close the database collector settings.
  7. In the model, click 
    Insert excerpt
    _save
    _save
    nopaneltrue
    .

...

  1. Hover your mouse pointer over the
    Insert excerpt
    _database_collector
    _database_collector
    nopaneltrue
     .
  2. In the pop-up popup toolbar, click 
    Insert excerpt
    _table_with_attributes
    _table_with_attributes
    nopaneltrue
    . PhixFlow adds the new stream to your model.
  3. In the model window, click 
    Insert excerpt
    _save
    _save
    nopaneltrue
    .

...

  1. To run analysis on your new stream hover your mouse pointer over the new stream, and in the pop-up popup toolbar, click 
    Insert excerpt
    _run_analysis
    _run_analysis
    nopaneltrue
    .
  2. To view the data you just loaded, hover over the stream and click 
    Insert excerpt
    _view_show
    _view_show
    nopaneltrue
    . In the drop-down list, select
    Insert excerpt
    _view_default
    _view_default
    nopaneltrue
    .