Versions Compared

Key

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

...

  • Create a new model called Build full customer details
  • Drag on the datasource CRM
  • Create a database collector and stream to read data into CenterView from following tables in the CRM datasource:
    • SOURCE_ADDRESS_LIST
    • SOURCE_CC_LIST
  • Merge these two streams:
    • Select both streams
    • Right-click on the model pane background and select Merge Selected Streams
    • Call the new stream Full Addresses
    • In the merge attributes form that pops up drag NAME into both boxes – we will merge the data from the two sources on the NAME field
    • Press Image RemovedPress Image Added
    • In the Automatic Stream Configuration form accept the default (All Attributes) and press Image Removedpress Image Added
  • Double-click the merge stream that is created – you will see the key field (NAME) has the expression _key[1]
  • Run analysis on Full Addresses and view the results

...

  • Again using the Datasource CRM, create a collector and stream to load into CenterView data from the table SOURCE_POSTCODE_LIST
  • Create a lookup pipe from the new stream SOURCE_POSTCODE_LIST to Full Addresses
  • Call this lookup pipe: pc
  • In the matching attributes form for the pipe create matches:

    Left-hand (post code reference data - SOURCE_POSTCODE_LIST)

    Right-hand (output - Full Addresses)

    HOUSENAMEORNUMBER

    in1_HOUSENAMEORNUMBER

    STREETNAME

    in1_STREETNAME

    TOWN

    in1_TOWN

    COUNTY

    in1_COUNTY

  • Drag the attribute POSTCODE from SOURCE_POSTCODE_LIST to Full Addresses
  • Run analysis on Full Addresses and view the results