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