O'Reilly logo

TIBCO Spotfire for Developers by Manuel Xavier

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Preparing and transforming the data

As already emphasized, in Spotfire, the data loaded into data tables is crucial for successful visualization creation. It must be in a workable format (or a format suitable for aggregation) as Spotfire's data table data manipulation capabilities are somewhat limited.

This does not mean, however, that Spotfire cannot perform some work on the loaded data. The tool has the following loading and transformation capabilities:

  • Data loading: It includes:
    • Adding a data table
    • Inserting data table columns
    • Inserting data table rows
  • Data transformation: It includes:
    • Pivoting the data
    • Unpivoting the data
    • Calculating and replacing the column
    • Calculating a new column
    • Changing the column name
    • Changing the column data type
  • Replacing data ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required