Data Wrangling and Transformation Flashcards

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

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.

Which transformation in Spotfire 'unpivots' a wide table by converting column headers into row values?

Answer: Unpivot (Melt)

Unpivot converts multiple columns into two columns (variable name and value), reshaping wide data to long format.

What does a 'Calculated Column' in Spotfire allow you to do?

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.

In Spotfire, what is the difference between a 'Row filter' and a 'Column filter' transformation?

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.

What does the 'Replace Column' transformation do in Spotfire Data Canvas?

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.

Which join type in Spotfire keeps ALL rows from the left table and only matching rows from the right table?

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.