UNION Operation

The UNION operation enables you to manipulate the data coming from different datasources. Follow these steps to add and configure a UNION operation in the data flow:

1.

UNION operation should have at least two data inputs on which the operation can be performed. Drag the UNION node towards the node to which you wish to connect it to.

2.

Once the UNION operation is successfully added to the data flow diagram, the Union Configuration pane is displayed below the canvas. All the columns from both the data inputs are displayed. Click on the + button next to the column to add the UNION operation and X button to delete it. You also have the option to do a “UNION ALL” as well to “Auto Match the Columns”.

3.

The data preview pane on the right displays the result set data.

Features and Limitations of the UNION Operation

•

The UNION operation can have unlimited inputs. But there must be at least two inputs and can have only one output.

•

This operation can be added after any operation except the Publish operation.