Hey guys I have a question on the Switch activity, here’s what I’m trying to do:
I have three cases that variable1 can hold a value of “A”, “B”, or “C”. Depending on which of those three it holds it will then assign variable2 to one of three different SQL databases.
I basically want to say if varaible1 = “A” then do case 1, if variable1 = “B” then do case 2, if variable1 = “C” then do case three.
In the switch the expression is set to variable1, but I still don’t know how to delineate if variable is equal to “A”, if variable1 is equal to “B”, etc. Without then putting an if statement into the three different cases, which is the whole reason I’m trying to use the case statement.