Data Wrangling and Transformation Flashcards

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

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

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

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

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

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.

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

Answer: Locks the leftmost columns so they remain visible when scrolling horizontally

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

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

Answer: Split column

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

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

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

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

In Spotfire, what does 'Replace values' transformation do?

Answer: Substitutes specific cell values matching a condition with a new value

Replace values scans a column for matching values or patterns and overwrites them with a specified replacement value.