Case Statement in Alteryx.

Question

Hello Team,

How can we create a Workflow in Alteryx for SQL case statement.

CASE
    WHEN condition1 THEN result1
    WHEN condition2 THEN result2
    WHEN conditionN THEN resultN
    ELSE result
END;

RolandSchubert · Accepted Answer

Hi @rohit782192 ,

in Alteryx, you use:

IF condition THEN

statement

ELSEIF condition THEN
statement
ELSEIF condition THEN
statement

ELSE

statement
ENDIF

So the difference is - no case, first condition is "IF", other conditions are "ELSEIF", ENDIF replaces END and no semicolon needed.

Best,

Roland

amruthas2 · Accepted Answer

You can use Switch statement in Alteryx.

Example - 
Month
01

02

03

Output Expected -

Jan

Feb

Mar

Create Formula -

Switch(

ColumnName,"Default Value",

"01", "Jan",

"02","Feb",

"03","Mar"

)