EXCEPT Operation

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

1.

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

2.

Once the EXCEPT operation is successfully added to the data flow diagram, the Except 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 EXCEPT operation and X button to delete it. You also have the option to do a “EXCEPT 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 EXCEPT Operation

•

The EXCEPT 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.