Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • 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 Image Modified
  • 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

...