Using the Pivot and Unpivot commands with Tabular …
Feb 27, 2025 · The Tabular Transformation connector provides both a pivot and unpivot command. To ensure that these are used properly, we've outlined the use cases that each …
Design a view as a flat or pivot table – Support Center
Sep 15, 2025 · To represent query results in a tabular format, set up the view as flat or pivot table. For example, you can design the view as a flat table for general reference or analysis, or a …
What is the difference between a 'transform' and 'pivot' command?
Jan 29, 2025 · The "transpose" command performs this action across all fields of the data set. This is not to be confused with a pivot command which rotates a single field along the vertical …
Create a View (of query results) – Support Center
Apr 25, 2025 · Note: To automatically create or update a pivot view of a query's results, build a chain with a Create Pivot View or Update Pivot View command through a Workiva connection.
Tabular Transformation – Support Center - Workiva
Using the Pivot and Unpivot commands with Tabular Transformation On this page: Platform Platform Overview Why Workiva? Generative AI Unified Reporting Data Management …
Connect pivoted data to spreadsheets with crosstab queries
Mar 8, 2024 · To specify the data to pivot, create a query in Wdata. You can create a query with a drag-and-drop builder or, if comfortable with Structured Query Language (SQL), a SQL editor.
Tabular Transformation commands – Support Center
Feb 5, 2024 · If you pivot the MEASURE column, aggregate the Amount column, and specify the remaining columns as rows, the output replaces the MEASURE column with columns for its …
CLP - Tabular Transformation – Support Center
Jul 3, 2024 · The Data Headers, Starting Pivot Column Name, Ending Pivot Column Name, Starting Pivot Column Index, and Ending Pivot Column Index fields are used to perform the …
Pivot data - Videos – Support Center
Jul 26, 2022 · You can pivot data to display your data in new ways for deeper analysis. Use pivots to analyze your data based on key data points. Pivot...
Example Workflows
Dec 22, 2025 · Pivot View Management Retrieve a list of pivot views Create a new pivot view Delete a single pivot view Retrieve a single pivot view Update a single pivot view Query …