After selecting sources , use the Join step to specify how the tables you selected relate to each other.
[Optional] Before creating connections between the tables, arrange them in the preferred join order.
The primary table is determined by the first join, and should be positioned as the leftmost table. A table becomes a primary table 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 the operators.
To edit a different join, click that join icon.
- To create more than one row of join conditions, click .
- To delete a row of join conditions, click .
- Create join conditions between each column, as needed.
- Click SAVE JOIN.
[Optional] You can change the order in which multiple joins are evaluated.
Numbers next to join icons indicate evaluation order.
- Click in the top bar.
- Click to change order.
- Click SAVE JOIN SEQUENCE.
[Optional] Select or clear the checkbox for the columns in each table.
Reducing the number of columns may be useful in steps where a list displays all the fields and you only need a subset.
- Click CONTINUE.