Pivot stages

The Pivot stage, an active stage, maps sets of columns in an input table to a single column in an output table. This type of mapping is called pivoting.

The Pivot stage pivots horizontal data, that is, columns within a single row, into many rows. It repeats a segment of data that is usually key-oriented for each column pivoted so that each output row contains a separate value.

An input column set can consist of one or more columns. The pivoting usually results in an output table that contains fewer columns but more rows than the original input table.

This stage has no stage or link properties. It merely maps input rows to output rows.