TIBCO Data Wrangling and Transformation 1 — Questions and Answers
Question 1: In TIBCO Spotfire, what is a 'Data Canvas' (formerly Data Flow)?
- A visual dashboard layout tool
- A graphical interface for building data transformation pipelines (Correct answer)
- A chart configuration panel
- A scripting IDE
Correct answer: A graphical interface for building data transformation pipelines
The Data Canvas provides a node-based UI for chaining data sources, transformations, and joins into a preparation pipeline.
Question 2: Which transformation in Spotfire 'unpivots' a wide table by converting column headers into row values?
- Pivot
- Unpivot (Melt) (Correct answer)
- Transpose
- Stack
Correct answer: Unpivot (Melt)
Unpivot converts multiple columns into two columns (variable name and value), reshaping wide data to long format.
Question 3: What does a 'Calculated Column' in Spotfire allow you to do?
- Summarize data at aggregate level only
- Create a new column derived from an expression evaluated per row (Correct answer)
- Filter rows based on conditions
- Join two tables together
Correct answer: Create a new column derived from an expression evaluated per row
A calculated column computes a new per-row value using Spotfire's expression language and stores it as an additional column.
Question 4: In Spotfire, what is the difference between a 'Row filter' and a 'Column filter' transformation?
- Row filter removes columns; column filter removes rows
- Row filter keeps or removes rows based on criteria; column filter keeps or removes columns (Correct answer)
- They are identical operations
- Row filter applies only to aggregated data
Correct answer: Row filter keeps or removes rows based on criteria; column filter keeps or removes columns
A row filter removes rows not meeting a condition, while a column filter removes unwanted columns from the dataset.
Question 5: What does the 'Replace Column' transformation do in Spotfire Data Canvas?
- Renames a column header
- Replaces all values in a column with a constant
- Substitutes an existing column with a new computed expression (Correct answer)
- Moves a column to a different position
Correct answer: Substitutes an existing column with a new computed expression
Replace Column substitutes an existing column's values with a new expression result, effectively overwriting it in place.
Question 6: Which join type in Spotfire keeps ALL rows from the left table and only matching rows from the right table?
- Inner join
- Left outer join (Correct answer)
- Full outer join
- Cross join
Correct answer: Left outer join
A left outer join retains every row from the left table and fills NULL for right-table columns where no match exists.
TIBCO Data Wrangling and Transformation 1
In TIBCO Spotfire, what is a 'Data Canvas' (formerly Data Flow)?