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

A visual dashboard layout tool

Answer

A chart configuration panel

Answer

A scripting IDE

Question 2

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

Accepted Answer

Unpivot (Melt)

Answer

Pivot

Answer

Transpose

Answer

Stack

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

Summarize data at aggregate level only

Answer

Filter rows based on conditions

Answer

Join two tables together

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

Row filter removes columns; column filter removes rows

Answer

They are identical operations

Answer

Row filter applies only to aggregated data

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

Renames a column header

Answer

Replaces all values in a column with a constant

Answer

Moves a column to a different position

Question 6

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

Accepted Answer

Left outer join

Answer

Inner join

Answer

Full outer join

Answer

Cross join