You can export data from TIBCO Spotfire and save as a text file, a TIBCO Spotfire Binary Data Format file (see below) or a Microsoft Excel file. The text file can be either a regular tab separated text file, or a Spotfire Text Data Format file. The Excel file can be either an XLS file or an XLSX file. Data from a visualization can only be exported to an Excel file if the visualization is a table.
Tip: You can use the Export Data from Visualization option when you want to export from in-db data tables. Note that for all visualizations other than the cross table you need to mark the items of interest before opening the Export Data dialog.
To export data from a visualization:
Select File > Export > Data....
Click the Visualization radio button.
Select the visualization to base the new data file on from the drop-down list.
Comment: You can export all or marked data from a table, cross table or a summary table, or the marked data from any other visualization. You can also select to export the data currently shown in the Details-on-Demand.
If both options are available
for the selected visualization, select whether to export:
Data for all items - the rows remaining after the current filtering.
Data for marked items - the currently marked rows. Note that
all marked rows will be exported, even if they are filtered out.
Comment: The Data for all items option is only available if you have selected a table, a cross table, a summary table, or the Details-on-Demand in the Visualization drop-down list. Data for marked items is only available if there are marked items in the analysis.
Click OK.
Specify a file name and a location for the file in the Save As dialog.
Click Save.
Comment: You can export the data to a text file, to an Excel file, to a TIBCO Spotfire Text Data Format file (*.stdf) or to a TIBCO Spotfire Binary Data Format file (*.sbdf). See below for more information.
Select File > Export > Data....
Click the Data table radio button.
In the drop-down list, select which data table to export data from.
Select what data to export:
All rows - the entire data table regardless of all filtering.
Filtered rows - the rows remaining after the current filtering
by the specified filtering scheme.
Marked rows - the rows marked in the visualizations using the
specified marking. Note that all marked rows will be exported, even
if they are filtered out.
Click OK.
Specify a file name and a location for the data file in the Save As dialog.
Click Save.
Comment: You can export the data to a text file, to an Excel file, to a TIBCO Spotfire Text Data Format file (*.stdf) or to a TIBCO Spotfire Binary Data Format file (*.sbdf). See below for more information.
The TIBCO Spotfire Binary Data Format stores the data and metadata from your analysis in binary form. It can be used to greatly increase the performance when working with linked data in TIBCO Spotfire.
The TIBCO Spotfire Text Data Format also includes metadata. For example, the data types of the columns are saved, so you do not need to specify any import settings when opening files of this data format in TIBCO Spotfire. If you select the TIBCO Spotfire Text Data Format (*.txt) you will be able to open the file in older versions of TIBCO Spotfire (before 3.1) and in TIBCO Spotfire DecisionSite, but you will not get all functionality of the Spotfire Text Data Format.
See also:
Saving an Analysis File in the Library