Data Wrangling and Transformation Flashcards

In Spotfire, what is an 'On-demand data table'?

Answer: A table that fetches data from the database only when triggered by a filter or parameter change

On-demand tables execute their query only when prompted by a filter, input control, or marking change, reducing unnecessary data loads.

What does the 'Pivot' transformation accomplish in Spotfire?

Answer: Converts row values into column headers, aggregating values

Pivot reshapes data from long to wide format by turning distinct values in a category column into new column headers.

In Spotfire, what is the purpose of 'Data relationships' between tables?

Answer: Define how two data tables are linked so filtered selections propagate between them

Data relationships tell Spotfire which columns link two tables so that markings and filters in one table affect the other.

Which Spotfire feature lets you combine rows from two tables with the same columns vertically?

Answer: Union

A union appends rows from two tables with matching column structures into a single stacked dataset.

What does 'Data on demand' setting 'Prompt for new data' mean in Spotfire?

Answer: Waits for user input in a prompt dialog before executing the data query

This setting displays a parameter prompt to the user before issuing the query, allowing customized query input.

In Spotfire, what is 'Column matching' used for when combining data tables?

Answer: Aligns columns by name or position when unioning or joining tables

Column matching maps columns from one table to another by name or position when performing union or join operations.