Modify stage

The Modify stage alters the record schema of its input data set. The modified data set is then output. You can drop or keep columns from the schema, or change the type of a column.

The Modify stage is a processing stage. It can have a single input link and a single output link.

The Modify stage alters the record schema of its input data set. The modified data set is then output. You can drop or keep columns from the schema, or change the type of a column.

Shows the Modify stage being used to modify the columns in an input data set before outputting the data to another data set

The stage editor has three pages:

Stage Page. This is always present and is used to specify general information about the stage.
Input Page. This is where you specify details about the input link.
Output Page. This is where you specify details about the modified data being output from the stage.

Although the Modify stage is classified as a processing stage, it does not behave in the same way as other processing stages. In the Monitor window of the Director client, the stage does not show processing rows, and the stage does not show an outgoing row count in the Designer client.