3 Replies Latest reply on Mar 11, 2017 10:52 PM by Deepak Rai

    Only include values found in another table (IN operator?)

    Alexander Ashford

      Having a great deal of trouble with this problem, I'm wondering if any of you can help. Hoping this is simple:

       

      I have two datasets representing physical sites, one representing the sites themselves, one representing data collected about the sites. The datasets are linkable using an ID field that they both share. However, the second dataset contains data from many fewer sites than the first dataset has.

       

      I only want to include in my visualization sites whose data is complete (in other words, have entries in both datasets). If I was to do this query in another program language, I would use something like the "IN" operator, i.e. "from table2 include value if ID in table2". However, as far as I can tell there's no comparable feature in tableau.

       

      Any ideas?