Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

Creating an IF Statement in the Formula Tool

5 - Atom

I need to create an if statement that creates a new column, but I'm running into Syntax issues.

 

IF [TIME] IS NOT NULL

THEN .027

ELSE

NULL

END AS [NEW FIeld]

 

What is the Alteryx syntax for this?

 

 

Andrew_Seaman_1-1585259887518.png

 

Highlighted
Alteryx Certified Partner

The syntax would be

IF !(ISNULL([TIME]) THEN 0.27

ELSE NULL()

ENDIF

 

Remove the space in ENDIF

Labels