I have a process which opens an excel file from the Orchestrator queue, and then depending on which excel file it has open, performs different actions. For this I used a switch rather than nested if functions, however it doesn’t seem to work as is, so was looking for some help please.
The file opens, then the process skips the switch activity altogether. The file names are more complex than the single words, but these are the unique identifier words, and *wildcards don’t work with .contains as far as I know. TypeArgument is also a String.
I’m sure it’s something very simple I’m missing so please let me know.
Yes… the way you have configured your Switch activity is bit wrong
For the expression, just use the variable name as it is. - you have already done it and it looks fine.
Change the Type Argument of the switch activity to String
Now, in every case, just mention the value you are looking for in the variable. You don’t need to write the code there.
Buddy the reason is the contains actually gives us true or false boolean type of value
and when you are passing an expression strFileToOpen of type string and getting compared with case value of type boolean…there comes the mismatch buddy… @Alex_Cross
so in order rectify this let the expression be same with strFileToOpen and in cases pass all the values of file name that you have in orchestrator…so
if the strfiletoopen with string when gets compared to the case value of type string…which actually has any one of the value of strfiletoopen,will match and get you to that case and related activities in it
Try this buddy and let know whether this works or not buddy
Cheers @Alex_Cross
Thanks both for your help, looks like I’m half way there now! As you can see below, it opens the files (when I logged into the VM all 5 excel files were open) but it doesn’t seem to perform any of the required processes, much like before, except this time at least it doesn’t error, just skips past and ends transaction with no errors?
Remove all the speech marks from your Cases. The switch is trying to match “Demand” rather than Demand which is causing it to follow the default case. That is why you aren’t getting any errors
Buddy thats great
you were almost done
but one this make sure you have type argument of switch case as string
and if so dont put double quotes for any string in any of the cases
remove that buddy and try
you will get it for sure
see for example when i tried like this i didnt get any thing
Anil_G
ashokkarale
Ajay_Mishra
Gautham_Pattabiraman
BHUSHAN_NAGAONKAR1
vrdabberu
ABHIMANYU_THITE1
lrtetala
samantha_shah
shyamala_shyamu