Define advanced data relations

Use this procedure to define more complex relationships.

  1. Click the Advanced button at the bottom left of the Define Condition editor, and click Edit condition.

    The Expression Editor appears.

  2. Click the Tables tab in the left menu of the Expression Editor window.
  3. From the Tables tab you can define the relationship by highlighting the relevant table field from the database and dragging it to the Expression Editor area.
  4. Click the Operators drop-down menu to select an operator to add to the definition.
    Note If you make a mistake or wish to change the current expression, use Backspace in the top menu to clear the editor.
  5. In the Tables tab, select the other relevant column that you are including in this relationship, drag it into your expression editor, and click OK.
  6. In the Advanced Options section of the Add Source window, select the join type to use. The join type is based on how the two tables should be joined if no match is found between rows in parent and child tables.
    • Join of both tables (INNER JOIN): Only include a record from the parent table if a match is found in the child table.

    • All records from parent table and corresponding records from the child (LEFT JOIN): Include all records from the parent table even if no matches are found in the child table. Where there is no matching child row, there will be null values for fields coming from the child table.

    • All records from the child table and corresponding from the parent (RIGHT JOIN):

      Include all records from the child table even if no matches are found in the parent table. Where no matching parent row exists, there are null values for fields coming from the parent table.

    • All records from the parent and All records from the child (FULL JOIN): Include all records from both the parent and child tables.

  7. Click OK.

    The Child table is listed in the Sources field under the Mapping tab.