Hi, I met a problem that how to use condition if, when first meet or operator, then and operator, then get the result. like this :
if (contains("Ray",[A]) or [B]="003") and contains("Cheng") then "T" elseif contains("666",[D]) and [E]=0 then "A" ELSE "F" ENDIF
to get the "Expected Result"
Alteryx does accept my logic formula. Can someone solve this problem? Sorry, I am using 2018 version of Alteryx. Can not open the latest version file. Can you insert photo of the solving process by Alteryx?
Best Regards,
Lei
Solved! Go to Solution.
Hi @LeiCheng I mocked up a workflow that produces the output you describe. I used the syntax IF [A]="Ray" or B="003" and [C]="Cheng" THEN "T" ELSEIF [D]=666 and [E]=0 THEN "A" ELSE "F" ENDIF
Hi @LeiCheng this syntanx should assist with that scenerio IF [A]="Ray" or B="003" and [C] In ("Cheng","Yang") THEN "T" ELSEIF [D]=666 and [E]=0 THEN "A" ELSE "F" ENDIF
I use an In function which will search for all the parameters I input e.g. Cheng and Yang.
Hi, @JosephSerpis . It works! Thanks a lot!