How to filter out undesired data from the existing report and exclude it while reloading the data table in Spotfire

Product:TIBCO Spotfire Analyst
Versions:10.1 and higher

Summary:
How to filter out undesired data from the existing report and exclude it while reloading the data table in Spotfire

Details:
Filtering out data using filters, or deleting marked rows is not a permanent way of removing unwanted data from the Spotfire file. When reloading the data table, such datasets will be reloaded. In order to permanently exclude the unwanted data follow the steps mentioned in the Resolution section.
 

Resolution:
Step1 : In the Filters panel, filter the data to include only what you want to keep in the analysis.

Step2 : Right click the filter and select "Create Filter Transformation" from the pop-up menu.

Step3: A transformation is added to the data table where the filtered out data is excluded. You can review and edit the transformation from the Data canvas at any time.

Note: By editing the transformation, you can make it filter your data in other ways than what is possible using the filters alone, such as filtering OUT the selected value(s) instead (an example of such an expression, filtering out the values 1 and 2, would be "[MyColumn] NOT IN (1,2)")    

Note: In the Filters panel, you can press Ctrl and select more than one filter before right-clicking, if you want to base the transformation on more than one filter.


Note: When using "Marked Rows > Filter to" or "Marked Rows > Filter out", a temporary column is created of type 'Mask'. As per design it is not possible to create a Filter Transformation for this column.