Hi guys,
i'm new to alteryx. I was wondering how i can write this formula:
if [Column] >6 and <10 then [Column2]= "blue"
I am having a hard time understing how to place an "and" in order to have 2 conditions.
Thanks in advance!
Solved! Go to Solution.
Thanks for the iffy question.
IF [Column] > 6 AND [Column] <10 THEN "Blue" ELSE "Yellow" ENDIF
I assume that you are creating a new field, Column 2 in the formula tool. I also assume that for column 2 that if it isn't Blue that you want something else.
Cheers,
Mark
hin @max_hfr
Welcome to the community.
In writing conditional formulas, you need to define 3 things
so your final text in the formula box becomes
if [column1] >6 and [column1] < 10 then "blue" else "not blue" endif |
Dan