Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Filters
Created by Guest
Created on Apr 3, 2023

Add 'Exclude Filtered Rows' option for filtering related Data Tables

Request

Add Exclude Filtered Rows option for filtering related Data Tables.


Background

Currently, the three options are:

  • Include Filtered Rows

  • Exclude Filtered Out Rows

  • Ignore Filtering

In a scenario where users need a anti-join-esque behaviour, none of existing options work; thus, the need for the requested option.


Example

Data Table #1 values: [A, B, C, D]

Data Table #2 values: [A, C, E, F]

Given:

  • The two tables are related.

  • Table #1 is filtered to [A, B]

  • Goal is for Table #2 to show [C, E, F]


  • Attach files