Hi alteryx newbie here. I'd like some guidance on something that will very easy for the experience community.
I have a spreadsheet taken into alteryx which I need to query against and mark the values with two options, eg.
IF IsEmpty ([ColumnNameA])
THEN ([ColumnNameB]) = "Apples"
ELSE "Oranges"
ENDIF
But I want to say not only Oranges but Pear, Banana etc..
I am not sure how to finish it to give it the two/multiple options.
Many thanks in advance.
Solved! Go to Solution.
Hi @PamG
Are you meaning multiple IF statements? i.e
IF IsEmpty ([ColumnNameA])
THEN ([ColumnNameB]) = "Apples"
ELSEIF [ColumnNameA] = 123
THEN "Pear"
ELSE "Oranges"
ENDIF
Hey @PamG , You can use the formula tool as below and IF-ELSE Ladder for your multiple statements:
@grazitti_sapna & @DavidSkaife - thank you both for your help that worked for me. much appreciate speedy solution on this.