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

book

Article ID: KB0077312

calendar_today

Updated On:

Products	Versions
Spotfire Analyst	All Versions

Description

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.

Issue/Introduction

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

Resolution

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.

Additional Information

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

Feedback

thumb_up Yes

thumb_down No

Welcome to "KB Articles"