4.9 Transpose (Columns to Rows)

This section provides information about the Transpose (Columns to Rows) component.

1. Drag and drop the Transpose (Columns to Rows) component on the canvas to define a Transpose (Columns to Rows) Component on an EDD/ CLO.
2. To position the component on the canvas, drag and move the component, or click the component and use arrow keys on the keyboard to move it around.
3. The Transpose (Columns to Rows) component accepts input only from an EDD and can have only one output.
4. If you have multiple EDDs/ CLOs selected, and you want to have a Transpose (Columns to Rows) component for more than one EDD/ CLO, then you must select as many number of Transpose (Columns to Rows) components, connect each to its respective EDD/ CLO, and then define their expressions.
5. At any given time, right-click the component and select the relevant options to either delink, remove inlinks or outlinks, or delete the component.
6. Double-click the component to transpose the entity columns into rows. Specify the Unpivot Data Elements to transpose columns into rows.
7. Specify the Header Column Name and Value Column Name.
8. Specify the column value (Header column) and expression pair (Value column) for each transposed row. You must have a minimum of two pairs.
9. After specifying the Unpivot Data Elements, click Auto Transpose. This will transpose columns into rows based on the unpivot data elements selected.
10. Click Review to view the transformed data.
11. Click OK.