9.10.1.3 Creating Join

The Join widget enables you to combine or group multiple tables using various join operators.

To create a join, follow these steps:

1. Navigate to the Pipeline Designer page.
2. Drag and drop the Join widget from the widgets pane to the designer pane.
3. Hover on the Join widget and click Edit. A dialog box is displayed.
4. Enter the name in the Name field.
5. In the Output pane, follow these steps:
   1. Select the required tables from the drop-down lists on the left-hand side and right-hand side that you want to join.
   2. Select the join operators to join the two tables. For more information, see the Join Operators section.
6. Add a Join condition to the join table to save the widget.
7. To add a condition, click Add + on the right (Add Group and then Add Condition) and specify rules for the condition. You can add multiple groups and multiple conditions under each Group.
8. Click Save to save the changes. The join widget is created.
   You can perform certain common tasks in all the widgets, such as Edit, Delete, Filter, etc. For more information, see the Common Tasks section.