The Transform Pane

Transform allows you manipulate your columns to come up with a different way of viewing your data.

 

From this dialog, you can define:

Transform

Description

Sorts

Arranges the rows of a specific column in ascending or descending order.

Pivot Columns

Transform column values into column headers, in effect transforming data from a tall/skinny format to a short/wide one.

Unpivot Columns

Transform column headers into column values, in effect transforming data from a short/wide format to a tall/skinny one.

Transpose

Transforms a table so you may view each row on a vertical instead of horizontal axis

Group

Organizes your table so that all rows that have a common field value are brought together to provide a meaningful summary of your data.

Duplicates

Removes or shows duplicate rows in the table.

Extract Rows

Deletes or shows all rows that do not contain any data.

 

NOTES:

  • While data preparation operations are reversed/deleted using the Change History panel, table transformations are reversed/discarded by clicking on the drop-down arrow located to the right of the transformed table and then selecting Discard Transform from the options that display.
  • When the table you want to manipulate has errors (e.g., broken change list, invalid or missing source file), the application will display the following message: "This table has one or more errors. These must be fixed before proceeding. Make sure to address these errors before proceeding with transforming your data."

 

 

Related Links

 

 

 

© 2024 Altair Engineering Inc. All Rights Reserved.

Intellectual Property Rights Notice | Technical Support