KNOWLEDGE BASE

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

Question

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

Environment

  • Tableau Desktop
  • Blended Data

Answer

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?