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

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

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

   Insert excerpt
   _static _static nopanel true

   .
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 

  Insert excerpt
  _recordsets_show _recordsets_show nopanel true

  .

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 

   Insert excerpt
   _table_new _table_new nopanel true

   .
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 

   Insert excerpt
   _save_saveModel _save_saveModel nopanel true

   .

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