Filter Out Values in Primary Data Source Which Do Not Exist in Secondary Data Source

Published: 14 Apr 2016
Last Modified Date: 11 Aug 2017


How to filter values from primary data source that do not exist in the second data source.


  • Tableau Desktop
  • Blended Data


This example uses Superstore sample data and can be reviewed in the attached packaged workbook:
  1. In the secondary data source, add 'Order ID' to Filters.
  2. Select Null
  3. Select Exclude
  4. Press OK
  5. In the secondary data source, there should be a orange chain icon indicating the field is linked. If it's not currently visible, click the blue broken chain icon to blend the data.
Did this article resolve the issue?