ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

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

Nested IF statement multiple OR

13 - Pulsar

This is also a syntax error:





You can use an IN   

or you have to repeat the [Account ID] = 


A good place to get up to speed is under Learn > Academy > Learning Paths



13 - Pulsar

One more quick thing as presently constructed your if/then/else couldn't work because you are comparing one value against two different types of  of clauses. I don't know what type of variable your fields are but you cannot compare something to a number and to a string. That is an error.


You can have if [myfield] ="5" or [myfield6]= "a" but you can't have if [myfield]=5 or [myfield]= "a"

7 - Meteor

Super helpful, thank you!