Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Nested IF statement multiple OR

cmaraffi
6 - Meteoroid

Hi, I am trying to figure out what I am doing wrong here. Please help. Is there a better way to update multiple criteria with the four buckets?

 

cmaraffi_0-1619718145158.png

 

 

 

 

12 REPLIES 12
ChrisTX
15 - Aurora

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
18 - Pollux

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