...
- In your model, hover your mouse pointer over the
icon. In the pop-up popup toolbar, clickInsert excerpt _datasource _datasource nopanel true Insert excerpt _table_database _table_database nopanel true - In the list of tables that PhixFlow opens, scroll down to the
SOURCE_CUSTOMER_PHONE_NUMBERS
table name.- To have a look at the data in this table, double-click its name.
- You can see there are columns for ##CUSTOMER_REF and ##PHONE_NUMBER.
- Close this data form
- 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. - Double-click on the new database collector to open its settings.
- In the Basic Settings section → Statement Expression field, you can see that PhixFlow has added a database query.
- Close the database collector settings.
- In the model, click
.Insert excerpt _save _save nopanel true
...
- Hover your mouse pointer over the
.Insert excerpt _database_collector _database_collector nopanel true - In the pop-up popup toolbar, click
. PhixFlow adds the new stream to your model.Insert excerpt _table_with_attributes _table_with_attributes nopanel true - In the model window, click
.Insert excerpt _save _save nopanel true
...
- 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 nopanel true - To view the data you just loaded, hover over the stream and click
. In the drop-down list, selectInsert excerpt _view_show _view_show nopanel true
.Insert excerpt _view_default _view_default nopanel true