Query Column and mark it with multiple values

Question

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.

grazitti_sapna · Accepted Answer

Hey @PamG , You can use the formula tool as below and IF-ELSE Ladder for your multiple statements:

PamG · Accepted Answer

grazitti_sapna & @DavidSkaife - thank you both for your help that worked for me. much appreciate speedy solution on this.