Specifying a horizontal pivot operation

Use the Pivot Enterprise stage to horizontally pivot data to map sets of input columns onto single output columns.

You can design a horizontal pivot operation in a Pivot Enterprise stage and then map the columns onto the output columns.