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