Column Export stage

The Column Export stage is a restructure stage. It can have a single input link, a single output link and a single rejects link.

The Column Export stage exports data from a number of columns of different data types into a single column of data type ustring, string, or binary. It is the complementary stage to Column Import (see Column Import stage).

The input data column definitions determine the order in which the columns are exported to the single output column. Information about how the single column being exported is delimited is given in the Formats tab of the Input page. You can optionally save reject records, that is, records whose export was rejected.

In addition to exporting a column you can also pass other columns straight through the stage. So, for example, you could pass a key column straight through.

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 the details about the single input set from which you are selecting records.
• Output Page. This is where you specify details about the processed data being output from the stage.