TIBCO Data Wrangling and Transformation

Question 1

In TIBCO Spotfire, what is a 'Data Canvas' (formerly Data Flow)?

Accepted Answer

A graphical interface for building data transformation pipelines

Answer

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?

Accepted Answer

Unpivot (Melt)

Answer

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?

Accepted Answer

Create a new column derived from an expression evaluated per row

Answer

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?

Accepted Answer

Row filter keeps or removes rows based on criteria; column filter keeps or removes columns

Answer

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?

Accepted Answer

Substitutes an existing column with a new computed expression

Answer

Replace Column substitutes an existing column's values with a new expression result, effectively overwriting it in place.

TIBCO - Spotfire Practice Test