How to include filtered out values when copying data from a tabular visualization in TIBCO Spotfire

Created
October 08, 2021 23:18

Date Posted: 2019-08-30
Product: TIBCO Spotfire®

Problem:

Solution:

If you used filtering in a tabular visualization (e.g. Table, Cross Table or Summary Table), including using right click > Marked Values > Filter Out, the filtered out rows will then be removed from the visualization and not visible. If you copy all values in the tabular visualization, and then paste to another program, the filtered out values will be missing. In some cases, you may also want to include the full data set, including those filtered out values. To copy all values from the visualization, including the filtered out values, use Edit > Copy Special > Data for All Items. This will copy all the values in your underlying data table. Then if you paste the copied data into another program, you will see all the values including the filtered out rows. See Copying Data, Pages or Visualizations for more details. Doc: Exporting Data to File

https://docs.tibco.com/pub/sfire-analyst/10.3.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/export/export_data_to_file.htm

Doc: Copying Data, Pages or Visualizations

https://docs.tibco.com/pub/sfire-analyst/10.3.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/data/data_copying_data_pages_or_visualizations.htm