Transforming an underlying Data Table from Short/Wide to Tall/Skinny format is known as

Unpivoting is the specific data transformation operation used in TIBCO Spotfire to restructure a data table from a short/wide format to a tall/skinny format. This process converts columns into rows, creating a new category column and a new value column from the original column headers and their cell values. This transformation is essential for preparing data for certain types of visualizations and analyses where data needs to be aggregated or compared across categories that were originally represented as separate columns.

A. Calculation: This involves creating new columns using expressions based on existing data, not restructuring the table's fundamental layout from wide to tall.

C. Renaming Columns: This is a metadata operation that changes the name of a column but does not alter the structure or dimensions of the data table.

D. Pivot: This is the inverse operation of unpivot. It transforms data from a tall/skinny format to a short/wide format by converting row values into new columns.

E. Normalization: This is a broader database design concept aimed at reducing data redundancy and improving data integrity, not the specific name of the wide-to-tall transformation operation in Spotfire.

1. TIBCO Spotfire® Analyst User's Guide

Version 12.0 LTS

"Unpivoting data" section. The documentation states

"Unpivoting is a way to transform data from a wide

or cross-table

format to a tall

or stacked

format. When you unpivot

the data in a selection of columns is transformed into two new columns: a category column and a value column." This directly defines the process described in the question.

2. TIBCO Spotfire® Analyst User's Guide

Version 12.0 LTS

"Details on Unpivot" section. This section provides a visual example and further details: "The columns that you choose to unpivot are removed from the data table

and their names and values are added in the two new columns." This confirms the structural change from wide (multiple original columns) to tall (two new columns).