4 Replies Latest reply on Sep 29, 2016 3:48 PM by Jatin Kakani

    Alternative to using OR in CASE Statement

    Jatin Kakani

      I have a situation where I am using a case statement and I have to test multiple conditions and assign the same label for them.

      For eg,

      case choose
      when "a" then 1
      when "b" or "c" or "d" then 2

      ...

      Tableau doesn't allow me to use OR in case statement.

      I created a set with values b,c and d and tried to use it in my case statement, however it says comparison object in case must be a string.

       

      Please let me know if you have a work around for this.

       

      -Jatin