Pivot Transformation - Finish
Finishing the Transformation
When you have made all your selections, click the Finish button to return to the Table Preview. You could check what the Table Preview would show before you exit the transformation, using the option 'Show Preview', and updating that preview each time you make a change. However, the preview within the transformation will take all transformations that are applied within the table, even if one or more of them were temporarily disabled by deselecting the check box for that transformation. To view the Table Preview with just the transformations that you have selected, exit the Pivot Transformation and view the preview.
Adding Subsequent Transformations
The Pivot Transformation is reasonably tolerant of working together with subsequent transformations, such as creating table subheads from a column, or applying alternate tints on rows, etc. However, because the table has essentially been rebuilt you will not be able to refer to a column by its attribute. The only practical way to refer to a column, for example, is to refer to it either by its subtype or by its column number after the Pivot Transformation.