TIBCO Data Wrangling and Transformation 3

Question 1

In Spotfire Data Canvas, what does the 'Sample' transformation do?

Accepted Answer

Reduces the dataset to a random or first-N subset for faster development

Answer

The Sample transformation limits rows to a specified count or percentage, useful for prototyping with large datasets.

Question 2

What is the role of 'Data functions' in TIBCO Spotfire?

Accepted Answer

R or Python scripts that accept Spotfire data tables as input and return results

Answer

Data functions are R or Python (via TERR or external engines) scripts integrated into Spotfire that process data tables and return new tables or values.

Question 3

In Spotfire, what does 'Freeze columns' in a cross-table do?

Accepted Answer

Locks the leftmost columns so they remain visible when scrolling horizontally

Answer

Freezing columns pins them on the left so they stay in view as you scroll right through wide cross-tables.

Question 4

Which Spotfire transformation allows you to split a single column into multiple columns based on a delimiter?

Accepted Answer

Split column

Answer

Split column divides a text column into two or more new columns using a specified character or pattern as the delimiter.

Question 5

What is the function of 'Add rows' transformation in Spotfire?

Accepted Answer

Appends rows from a second data table to the current table (union)

Answer

Add rows is Spotfire's union operation, stacking rows from an additional table onto the current dataset.

TIBCO - Spotfire Practice Test

TIBCO - Spotfire Practice Test

TIBCO Data Wrangling and Transformation 3