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.
SOLVED

Nested IF statement multiple OR

ChrisTX
13 - Pulsar

This is also a syntax error:

 

ChrisTX_0-1619722623909.png

 

 

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

 

Chris

apathetichell
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"

Lili1
7 - Meteor

Super helpful, thank you!

 

Labels