List of Transformations

Apply Alternate Row Colors

Shades alternate rows according to a specified frequency.

Repeated Rule

Inserts specified rule styles as top and bottom borders of a row.

Attribute Formatting Transformations

Applies a transformation to a specific attribute.

Cell Formatting

Formats cells with specific content.

Row/Column Text Formatting

Applies text formatting to a specific column or row. The transformation also calculates, replaces, and applies prefixes and suffixes to values.

Assign Row/Column Types to Rows/Columns

Allows users to assign row and/or column types to fixed row / column numbers. This functionality is primarily intended for use after a Pivot Transformation has been applied.

Delete Table if Only Headers or Footers

Checks if all of the current rows or columns in a table are designated as Headers or Footers, i.e., if they are designated as anything other than Normal. If either all rows or all columns are headers or footers, then the entire table is deleted.

Fold Table

Divides a table into two or more side-by-side tables where the content flows across the tables.

Footnote Transformation

Controls how footnotes are displayed in a table.

Horizontal Fold Table

Splits a wide table into two or more vertical 'folds' based on a designated number of folds.

Horizontal Wrap Table

Splits a wide table into two or more vertical 'wraps' based on a specified column type.

Make Header Row from Column

Transforms column content into subheadings.

Merge Equal Cells

Merges adjacent cells with identical values. The transformation merges equal cells in the entire table or in specific rows or columns. Both horizontally and vertically adjacent cells are merged.

Merge Equal Rows/Columns

Merges consecutive rows or columns if they have identical data.

Merge Over Empty Cells

Merges row or column contents with empty cells. Use this transformation when you want to span dynamically created cell content.

Merge Rows/Columns

Merges the content of the specified rows or columns.

Move Units to Header

Enables a header row or header column to be built from unique units that appear on values inside the table. If all units are they same within the column or row, they are removed from the values and then moved into the new or existing header row / header column.

Pivot Transformation

Creates a pivot table that allows you to summarize and analyze the data in your table independent of the original data layout of your table.

Remove Attribute Rows/Columns in Group

Removes all attributes that belong to a specific attribute group.

Remove Empty Rows/Columns

Removes empty rows or columns. The entire row or column must be empty.

Remove Rows/Columns

Removes a specific row or column.

Row/Column Consolidation

Consolidates consecutive rows or columns that are identical except for the values in one designated row or column. The values in those cells corresponding to the designated row or column are merged.