11 Static Tables and Static Pipes

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

  • Create and use static tables
  • Create and use static pipes

When  Run Analysis is selected on a  Table, the tables preceding it are run first, so that the data contained is the most recent. When there is no need to run all of the tables that are connected, e.g. you have a static dataset which will not change, you can make a table or pipe Static. This ensures that the data in that table will not change - unless  Run Analysis is selected for that specific table.

Create and use a static table

  1. Create a model Static Streams and Pipes
  2. Drag the datasource CRM onto the model
  3. From this datasource, find the table SOURCE_CHANNEL_LIST, create a database collector and table to read this table into PhixFlow.
  4. Create a database collector and table to read data from the table SOURCE_CHANNEL_DESCRIPTIONS into PhixFlow.

You will use the table SOURCE_CHANNEL_DESCRIPTIONS as reference data to look up the description for each channel listed in SOURCE_CHANNEL_LIST:

  1. Hover over SOURCE_CHANNEL_DESCRIPTIONS and press Static.
  2. Run analysis on SOURCE_CHANNEL_DESCRIPTIONS to load data into the table.
  3. Add a lookup pipe from SOURCE_CHANNEL_DESCRIPTIONS to SOURCE_CHANNEL_LIST
  4. Complete configuration of the pipe:
    1. Name the pipe: desc
    2. Create an Order/Index as follows:

      Left-hand (reference data - SOURCE_CHANNEL_LIST)

      Right-hand (output - SOURCE_CHANNEL_LIST)

      CHANNEL

      CHANNEL

  5. Drag the attribute CHANNEL_DESC from SOURCE_CHANNEL_DESCRIPTIONS to SOURCE_CHANNEL_LIST
  6. Run analysis on SOURCE_CHANNEL_LIST


You should see that the data in SOURCE_CHANNEL_LIST is loaded, including the channel description looked up from SOURCE_CHANNEL_DESCRIPTIONS. However, look at the table sets for SOURCE_CHANNEL_DESCRIPTIONS:

  • From the hover menu of the table SOURCE_CHANNEL_DESCRIPTIONS, press  Show Recordsets.

You should see that it has only run once. Compare the run dates with the table sets in SOURCE_CHANNEL_LIST. You will see that SOURCE_CHANNEL_DESCRIPTIONS was not run when you ran SOURCE_CHANNEL_LIST - SOURCE_CHANNEL_DESCRIPTIONS, it only ran when you ran it on its own.

Create and use a static pipe

  1. Hover over SOURCE_CHANNEL_LIST and press  Create New Table.
  2. Call the new table Customer Channel Copy
  3. Copy all attributes from SOURCE_CHANNEL_LIST to Customer Channel Copy
  4. Click on the pipe and in the Basic Settings, select the tick box Static.
  5. Run analysis on Customer Channel Copy.
  6. In the model window, click  Save.

You will see that the data in the table is generated, but that SOURCE_CHANNEL_LIST did not run.