After selecting sources
, use the Join step to specify how the tables you selected relate to each other.
-
[Optional] Arrange tables in the preferred join order.
The primary table, which must be located in the leftmost table, is determined by being the first source node.
- From Joins, create a connection between two tables by clicking on one node and dragging to the other table.
-
From Edit Join, select the join type, fields that are relevant to both tables, and operators.
Option Action Create more than one row of join conditions Select Delete a row of join conditions Select Edit a different join Select the join
- Create join conditions between each column, as needed.
- Select Save Join.
-
[Optional] You can change the order in which multiple joins are evaluated.
Numbers next to join icons indicate evaluation order.
-
Select
in the top bar.
-
Select
to change order.
- Select Save Join Sequence.
-
Select
-
[Optional] Select or clear the check box for the columns in each table.
Selecting only needed columns is useful in steps where a list displays available fields for selection.
- Select Continue.