Query Column and mark it with multiple values

[PamG]

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.

[davidskaife]

Hi @PamG 

Are you meaning multiple IF statements? i.e

IF IsEmpty ([ColumnNameA])
THEN ([ColumnNameB]) = "Apples"

ELSEIF [ColumnNameA] = 123

THEN "Pear"
ELSE "Oranges"
ENDIF

[grazitti_sapna · Accepted solution]

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

[PamG · Accepted solution]

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