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



      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.