4.8 Using Transpose (Rows to Columns)

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

1. Drag and drop the Transpose (Rows to Columns) component on to the canvas.
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 (Rows to Columns) component accepts input only from an EDD/ CLO and can have only one output.
4. If you have multiple EDDs/ CLOs selected, and you want to have a Transpose (Rows to Columns) component for more than one EDD/ CLO, then you must select as many number of Transpose (Rows to Columns) 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 rows into columns. Specify the pivot data element to transpose rows into columns.
7. Specify the Column name - matching row value – Expression combination. You must have a minimum of two combinations.
8. Click Review to review the transformation. The sample of the transformed data is displayed.
9. Click Ok.