Siebel Marketing Guide > External Data Mapping > Joining Tables and Fields >

Joining Fields

Use the Fields list to specify a join's sequence, the parent and child fields, and the operator.

To join table fields

  1. From the application-level menu, choose View > Site Map > Marketing Administration screen.
  2. From the Show drop-down list, choose External Data Mapping.
  3. Click the Joins view tab.
  4. In the Joins list, select a join record.
  5. In the Fields list, create a new record.

    6. A new row is added with a sequence number.

    The read-only Sequence field displays the join order. Siebel Marketing adds a number 1 in the Sequence field to indicate this record is the first join field between the two tables. If the tables can be joined on multiple fields, make sure each join follows the same order as in the customer hierarchy.

    For example, if the customer hierarchy has SSN as the first targeting level and Account_ID as the second, make the SSN join first and the Account_ID join second when joining tables that have both fields. This allows Siebel Marketing to perform a merge join between the two tables. For more information, see Understanding Joins.

  6. Complete the necessary fields.

    7. NOTE:  Joined fields should not be greater than 255 characters.

    1. In the Parent Field field, click the select button.
    2. In the Pick Fields dialog box, select a field from the list of fields available in the Parent table and click OK.
    3. In the Child Field field, click the select button.
    4. In the Pick Fields dialog box, select the corresponding join field from fields available in the Child table and click OK.
    5. Choose a join type operator.

      6. Available operators are =, <, >, <=, and >=.

      The majority of joins use the = operator as the default. In this case, when the marketing server joins a row from the parent table, it looks for the same value in the child table.

      Some joins use the >= operator. This operator is most commonly used with date data, where the parent field contains an event date and you want to join to child data that occurred after the parent event.


 Siebel Marketing Guide, Version 7.5, Rev. A 
 Published: 18 April 2003