...

Create a database collector from the datasource schema browser

1. In your model, hover your mouse pointer over the 

   Insert excerpt
   _datasource _datasource nopanel true

    icon. In the pop-up toolbar, click  

   Insert excerpt
   _tables _tables nopanel true

   
   

   Info
   If you cannot see the table required it might be on another page. You can filter on the table name header, or use the paging bar to increase the page size or select the next page.

   
   

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 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 nopanel true

   .

...