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"



      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.