1 Reply Latest reply on Sep 20, 2012 3:40 PM by Tracy Rodgers

    "IN" function

    Heather Campbell

      Is there an "IN' function in Tableau similar to SQL.  It would really help simplify writing multiple OR statements.

       

      SQL:

      if [CONTACT_PURPOSE_CODE] in ('R', 'Y', 'Z', 'C') ... vs.

       

      Tableau:

      if ([CONTACT_PURPOSE_CODE]='R' or [CONTACT_PURPOSE_CODE]='S' or [CONTACT_PURPOSE_CODE]='Y' or

      [CONTACT_PURPOSE_CODE]='Z' or [CONTACT_PURPOSE_CODE]='C') and

      [AUTHOR_IND]='Y' then [Participant Name] end

       

       

      thanks!