An analysis in TIBCO Spotfire may be based on data from one or multiple data tables. There are different ways to add data to an analysis – rows and columns can be added to an existing data table and new data tables can be added to the analysis.
Overview
The different ways to add data are suitable for different needs and this section will describe the differences between them.
In general, a visualization in TIBCO Spotfire can only contain data from one data table, even if separate data tables are related to each other. Therefore, if you want to display the new data in the same visualization as the existing data table, you should add rows or columns to that data table, not add a new data table to the analysis.
Adding New Rows to a Data Table
It is possible to add new rows to an existing data table. This is useful if new data, related to the existing data table, is available. In order for the rows to match the existing data table completely, the data table with the new rows may need to be transformed and columns with different names need to be matched.
For more information on how to add rows to an existing data table, see the following topic in the TIBCO Spotfire User's Guide:
Adding New Columns to a Data Table
It is possible to add new columns to an existing data table. This is useful if you have a new data table with common columns to the existing one but want to add further aspects to the analysis through one or more new columns. In order for the columns to match the existing data table completely, the data table with the new columns may need to be transformed.
For more information on how to add columns to an existing data table, see the following topic in the TIBCO Spotfire User's Guide:
For an example on how columns are added to an existing data table, see the following topic in the TIBCO Spotfire User's Guide:
Adding New Data Tables to an Analysis
A new data table can be added to an analysis. The new data table can be independent or related to the existing one. If it is related, filtering or markings done in one data table may affect the other. This can be useful if one column in the existing data table, for example containing rows with unique customer ID:s, relates to a column with several rows of data in the new data table, for example containing all purchases made.
New, related data tables can be added "on demand". This means that all the data from the new data table is not retrieved at once. More information on data loaded on demand can be found in the Data on Demand page.
For more information on how to add a new data table to an analysis, see the following topic in the TIBCO Spotfire User's Guide:
For more information on how to handle related and independent data tables in an analysis, see the following topics in the TIBCO Spotfire User's Guide: