JOIN Operation
The JOIN operation enables you to manipulate the data coming from different datasources. Follow these steps to add and configure a JOIN operation in the data flow:
Drag and drop the JOIN operation into your canvas.
| 1. | JOIN operation should have two data inputs on which the operation can be performed. Drag the JOIN node towards the node to which you wish to connect it to. A connector appears between the two nodes indicating a successful connection. |
| 2. | Once the JOIN operation is successfully added to the data flow diagram, the Join Configuration pane is displayed below the canvas. The Join tab in the Join Configuration pane lets you choose a LEFT, RIGHT, INNER or a FULL JOIN and apply it to the data displayed in the preview pane. |
| 3. | In addition to specifying the type of JOIN in the Join tab, you can also build your own query expression in the Column tab. Click on the Source field to open the Expression editor. Use the helper tools to build your own expression. |
| 4. | The data preview pane on the right displays the result set data. |
Features and Limitations of the JOIN Operation
| • | The JOIN operation must have two inputs and can have only one output. |
| • | This operation can be added after any operation except the Publish operation. |