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

Formula component - OR

Alex_A
7 - Meteor

HI, I am trying to use an OR operator with a field formula i.e. - IF [SDLNTY]="CN,DN" THEN 0 ELSE [SDSOQS] ENDIF = So if the reference column(SDLNTY) contains the string CN Or the string DN then the new field value should be 0 Otherwise it should show SDSOQS column.

I'm guessing this should be fairly straightforward but I wasn't able to find it out so far.

Appreciate the help!

 

1 REPLY 1
vishwa_0308
11 - Bolide

Please try this :

 

IF [SDLNTY] in ("CN","DN") THEN "0" ELSE [SDSOQS] ENDIF

 

Vishwa

Labels