How to define a join condition

1	In the graphical information object editor, choose Joins.

2	In the upper pane, drag the join column from the first information object or map, and drop it on the join column in the second information object or map.

The upper pane shows the join condition, like the one in Figure 3-19, and the join columns and operator are listed in the lower pane.

Figure 3-19

Joined columns from two information objects or maps

3	In the lower pane, select the row that describes the new join condition.

4	If necessary, select a different join condition operator from the drop-down list. By default, Information Object Designer uses the equality operator (=) to relate two columns.

5	To change a column name to an expression, select the column name, and type the expression, or choose Ellipsis to display the expression builder, as shown in Figure 3-20.

Figure 3-20

Defining a join

If the join has a condition that uses an operator other than equality (=) or an expression, the upper pane marks the join line with the symbol that appears in Figure 3-21.

Figure 3-21

A join condition that uses an expression or an operator other than equality

6	If the join consists of more than one condition, repeat this procedure for the other conditions.

7	Choose one of the following join types:

Inner join

Left outer join

8	Optimize the join.

Copyright Actuate Corporation 2012