One question that I get all the time when people are looking at Spotfire analysis files is 'This data does not look like the raw data, what transformations and calculations were applied?' This can be useful if you need to keep a log or record of all actions applied to the data, or if you just want to understand the steps performed in order to replicate them on similar data.
TIBCO Spotfire captures the 'Source Information' for each Data Table. This 'Source Information' acts as a recipe of how the Data Table was generated, started with loading the raw data, merging in any columns and rows, applying any transformations, and then adding any calculated columns, and any other manipulations on the data table , like renaming or freezing columns.
To access the Data Table properties from within TIBCO Spotfire Professional, click on Edit > Data Table Properties.
Click on a Data Table and then select the 'Source Information' tab.
Publish
