TCP-SP practice question 10 of 15

Identify the function of the Pivot transformation

Full set: 60 questions

Domain Working with Data

Answer options
A: Pivots row values into columns of data Correct answer
B: Pivots column values into rows of data
C: Pivots row values to eliminate duplicates
D: Pivots column values to summarize correlated data
Correct Answer:
A. Pivots row values into columns of data
Explanation

The Pivot transformation in TIBCO Spotfire is used to restructure a data table from a "tall/narrow" format to a "wide/short" format. It accomplishes this by taking the unique values from a single categorical column and converting them into multiple new columns. The values for these new columns are populated from a separate value column, often using an aggregation method. This process effectively pivots data from a row-oriented structure to a column-oriented one.

Why Incorrect

B. Pivots column values into rows of data: This describes the function of the Unpivot transformation, which is the inverse of Pivot, converting a wide data format into a tall one.
C. Pivots row values to eliminate duplicates: While aggregation during a pivot can handle multiple values for a given intersection, the primary purpose is data restructuring, not duplicate elimination.
D. Pivots column values to summarize correlated data: This is an overly general and imprecise description. The core function of Pivot is a specific structural transformation, not just general summarization.

References

1. TIBCO Spotfire Analyst User's Guide

Version 12.0 LTS

"Pivoting data" section: "Pivoting is a way to turn data from a 'tall/narrow' format to a 'wide/short' format. It is done by turning the unique values in one column into multiple new columns."

2. TIBCO Spotfire Analyst User's Guide

Version 12.0 LTS

"Details on Pivot Data" dialog: This section details the configuration

requiring the user to specify "Columns to pass through"

"Column to pivot"

and "Columns to transfer and aggregate with"

confirming the mechanism of turning row values into new columns.

3. TIBCO Spotfire Analyst User's Guide

Version 12.0 LTS

"Unpivoting data" section: "Unpivoting is a way to turn data from a 'wide/short' format to a 'tall/narrow' format... This can be seen as the reverse of a pivot transformation." This reference explicitly contrasts the two functions

confirming why option B is incorrect.

Scroll to Top