2 Replies Latest reply on Apr 20, 2018 6:12 AM by suresh.gooty

    Help in building case when

    Grishma Achrekar

      Hello All,

       

      I want to build a "case when" statement that looks something like this

       

      Case contains(StateTag , <<Value>>) = TRUE

      when <<Value>> = "1" then 'maharastra'

      when <<Value>> = "2" then 'delhi'

      when <<Value>> = "2,3,4" then "NCR"

      end

       

      How do i go about such a statement ?

       

      I cannot use "IF ELSE" because in case of NCR it wont work. if it finds 2 it will name it Delhi and move to ELSE .

      But i want it to check all StateTags and name it whereever there is 2.

       

      Any other way than case when is also welcome.

       

      Thanks