Forum Discussion

v_mark's avatar
v_mark
Icon for Helper V rankHelper V
5 years ago
Solved

Switch Statement for multiple text criteria

I was creating a switch statement for all the states in the US and Group them into per region.  that will be used for a filter

 

I noticed that I have to declare each state in my switch statement. Just like below

State Groups = SWITCH( TRUE(),
sample[State] = "WV" , "CAPITAL",
sample[State] = "DE" , "CAPITAL",
sample[State] = "DC" , "CAPITAL",
sample[State] = "MD" , "CAPITAL",
sample[State] = "VA" , "CAPITAL",

 

and the rest goes on. 

 

Is there a way to combine at least or write an OR statement instead of having 50+ lines? 

@dax @help
@NeedHelp
  • amitchandak's avatar
    amitchandak
    5 years ago

    v_mark , I am adding in and Or example , both will work same in this case

     

    State Groups = SWITCH( TRUE(),
    sample[State] in{ "WV", "DE","DC","MD","VA"} "CAPITAL", // how to use in
    sample[State] = "DE" || sample[State] = "DC" || sample[State] = "DE" , "CAPITAL", //how to use OR

    "NA" //deafult va;ue
    )

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    v_mark , I am adding in and Or example , both will work same in this case

     

    State Groups = SWITCH( TRUE(),
    sample[State] in{ "WV", "DE","DC","MD","VA"} "CAPITAL", // how to use in
    sample[State] = "DE" || sample[State] = "DC" || sample[State] = "DE" , "CAPITAL", //how to use OR

    "NA" //deafult va;ue
    )