...
- Create a model Static Streams and Pipes
- Drag the datasource CRM onto the model
- From this datasource, find the table SOURCE_CHANNEL_LIST – create a database collector and stream to read this table into CenterViewPhixFlow
- Create a database collector and stream to read data from the table SOURCE_CHANNEL_DESCRIPTIONS into CenterViewPhixFlow
You will use the Stream SOURCE_CHANNEL_DESCRIPTIONS as reference data – to look up the description for each channel listed in SOURCE_CHANNEL_LIST:
- Hover over SOURCE_CHANNEL_DESCRIPTIONS and press
- Run Analysis on SOURCE_CHANNEL_DESCRIPTIONS to load data into the Stream
- Add a lookup pipe from SOURCE_CHANNEL_DESCRIPTIONS to SOURCE_CHANNEL_LIST
- Complete configuration of the pipe:
- Call the pipe desc
Create a match:
Left-hand (reference data - SOURCE_CHANNEL_LIST)
Right-hand (output - SOURCE_CHANNEL_LIST)
CHANNEL
CHANNEL
- Drag the Attribute CHANNEL_DESC from SOURCE_CHANNEL_DESCRIPTIONS to SOURCE_CHANNEL_LIST
- Run Analysis on SOURCE_CHANNEL_LIST
...
- Hover over SOURCE_CHANNEL_LIST and press press
- Call the new stream Customer Channel Copy
- Copy all attributes from SOURCE_CHANNEL_LIST to Customer Channel Copy
- Hover over the pipe and press
- Run Analysis on Customer Channel Copy
...