Transpose

Transposing datasets converts rows into columns and vice versa.

This conversion may be required to merge data tables prior to performing in-depth analyses.

The task interface is very minimal: it is made of only one tab, the Options tab, which contains a few options to set.

---

The Options tab

In the Options tab you can set the following parameters:

• Put attribute names as first column: if selected, attribute names will be displayed as the first column in the transposed table. If not selected the attribute names will be removed in the resulting dataset.

• Use first column as attribute names: if selected, the first column of the original dataset is used to determine the attribute names of the transposed table. If not selected generic names are employed.

---

Example

The following example uses the Sales dataset.

• After having imported the dataset, right-click on the import task and select Take a look to check the data.
  The dataset contains 3 attributes (2 integer attributes and 1 continuous attribute) and 12 rows.

• Drag a Transpose task onto the stage and link it to the import task.
  Double-click the task to open it and select both the Put attribute names as first column and Use first column as attribute names options (default value); then compute the task.

• Drag a Data Manager onto the stage: as we can see, the columns Month_ID, Year_ID and Sales have been converted to rows.