Spotfire has a whole host of transformations that you can apply to your data tables. I'm not going to document them all here—please refer to the Spotfire help if you need more information. Some of the operations you can perform are as follows:
- Calculate and replace column (use this if you want a calculated column but don't want to show the original source column)
- Calculate new column (adds a new calculated column)
- Change column names (provides an easy way to rename columns)
- Change data types
- Data function (runs a statistical function on the data)
- Exclude columns
- Filter rows
- Normalization (normalizes data so it falls between)
- Pivot
- Unpivot
- Group categorical data together with different values into a single value
- Replace a specific value (replaces a value in a data table—note that this option requires that a primary key or composite...