Free Trial

Alteryx Designer Desktop Discussions

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

Multiple conditional formulas using multiple columns

mlim0806
7 - Meteor

Hi Community, 

 

I am trying to create a new column labeled "Class" using multiple formulas from different columns. There are 4 levels of Class (0,1,2,& 3). Depending on the value in the position, criticality and staff ID field, this will populate the level. Level 2 is the only formula that will include IS NOT EQUAL. I am getting an error and I think it may be the "else" expression or possibly the order?

 

Logic on Levels:

 

IF [Position]="Chairman" or "Deputy Chairman" and [Criticality]= "Critical" then "Level 0"

IF [Position]="Vice Chair" or "National Partner" and [Criticality]= "Critical" then "Level 1

IF [Staff ID]= "24098" or "16000" then "Level 1"

IF [Position]!="Vice Chair" or "National Partner" or "Chairman" or "Deputy Chairman" and [Criticality]= "Critical" then "Level 2"

IF [Criticality]="Other" then "Level 3"

2 REPLIES 2
binuacs
21 - Polaris

@mlim0806 The IF Else statement was not correct

image.png

mlim0806
7 - Meteor

Thank you for the quick response! It worked! I had another formula further in the workflow that needed Staff ID to be a string, but I was able to use the select tool to just change it back. 

Labels
Top Solution Authors