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

1. , create a database collector and

1. table to read this table into PhixFlow.
2. Create a database collector and

1. 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

1. Insert excerpt
   _static _static nopanel true

   .
2. Run analysis on SOURCE_CHANNEL_DESCRIPTIONS to load data into the

1. table.
2. Add a lookup pipe from SOURCE_CHANNEL_DESCRIPTIONS to SOURCE_CHANNEL_LIST
3. Complete configuration of the pipe:

1. 1. Name the pipe desc

   2. Create

1. 1. an Order/Index as follows:

      Left-hand (reference data - SOURCE_CHANNEL_LIST)	Right-hand (output - SOURCE_CHANNEL_LIST)
      CHANNEL	CHANNEL

      
      

2. Drag the

1. attribute CHANNEL_DESC from SOURCE_CHANNEL_DESCRIPTIONS to SOURCE_CHANNEL_LIST
2. 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 

1. Insert excerpt
   _table_new _table_new nopanel true

   .
2. Call the new

1. table Customer Channel Copy
2. Copy all attributes from SOURCE_CHANNEL_LIST to Customer Channel Copy
3. Hover over the pipe and

1. press 

   Insert excerpt
   _static _static nopanel true

   .
2. 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.