4 Replies Latest reply on Aug 29, 2013 7:39 AM by Heidi Barnes

    flag record from one data source if it exists in another data source

    Heidi Barnes

      Hello,

       

      I would like to create a flag on my main datasource if the id exists in a second datasource in the workbook.  I know there must be an easy way to do this, but I'm not quite sure where to begin.

       

      I can easily do this in sql with a case statement, but how does this translate into Tableau?

       

      case when customerid in (select customerid from table b) then 1 else 0 end

       

      thanks much!

       

      ----

       

      I should probably also add that my ultimate goal is to use this flag as a filter to exclude these customers from the analysis.