Creating Joins

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. Follow these steps in the Output pane:
   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 Join Operators.
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.
9. You can perform certain tasks that are common in all the widgets, such as edit, delete, filter, and so on. For more information, see Common Tasks.