Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Switch Statement with multiple columns and conditions

nsarayar
7 - Meteor

Hi

Is it possible to have a switch statement that uses multiple columns and conditions or am i best using multiple IF statements

 

So i want my condition to be

If CaseComment or ReviewNotes contains "REJECTED BY FCR" then Referral Reason = "REJECTED BY FCR"

If CaseComment or ReviewNotes contains "REJECTED BY ESR" then Referral Reason = "REJECTED BY ESR"

If CaseComment contains "ESCALATION" and ReviewNotes contains "Unclear Reason" or if CaseComments contains "Unclear Reason" then Referral Reason = "UNCLEAR REASON FOR ESCALATION"

There 20 additional rules ...

 

nsarayar_0-1661938541307.png

 

1 REPLY 1
IraWatt
17 - Castor
17 - Castor

Hey @nsarayar,

Switch statements can have one value:

 

Switch(Value,Default,Case1,Result1,...,CaseN,ResultN)

 

This would mean you would have to create a value for each of your conditions which would be very had to understand logic.

 

You could try using the find and replace tool as that would avoid nasty IF statements:

IraWatt_0-1661939575476.png

Though with the logic above I'm not sure how well that would work.

 

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

 

Labels
Top Solution Authors