Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
There's still time to register for the Q3 ACE Panel - Spatial Edition presentation tomorrow! | Need more information about the event? Check out the post here
SOLVED

Case Statement in Alteryx.

Highlighted
8 - Asteroid

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;

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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

Labels