Spotfire: Add an Unpivot transformation from the Data canvas

Created
May 11, 2023 15:49

Prior to this task:

✔ Data must be loaded.

✔ Data canvas must be opened.

1️⃣ Data canvas ➡ Data tables ➡ select "data table name"
2️⃣ Data canvas ➡ select [Click to see operations...] ➡ select [Add transformations]
3️⃣ Transform data window ➡ Transformations ➡ select Unpivot
4️⃣ Transform data window ➡ select [Insert]
5️⃣ Unpivot Data window ➡ Available Columns ➡ select column(s)
6️⃣ Unpivot Data window ➡ Columns to pass through ➡ select [Add]
7️⃣ Unpivot Data window ➡ Available Columns ➡ select column(s)
8️⃣ Unpivot Data window ➡ Columns to transform ➡ select [Add]
9️⃣ Unpivot Data window ➡ select Category column name (contains transformed column names) ➡ select Data type Value column name ➡ select Data type Include empty values
🔟 Unpivot Data window ➡ select [OK]
1️⃣1️⃣ Transform data window ➡ select [OK]

Supporting Knowledge

The Unpivot transformation allows the data table to change from a short/wide format to a tall/skinny format.

Alternatively, the user can apply an Unpivot transformation when loading data. Select [Files and data], then from the Add data to analysis panel, select [Transform data].

Related articles