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. Hover over the pipe and press 

   Insert excerpt
   _static _static nopanel true

   .
5. Run analysis on Customer Channel Copy

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