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?
Solved! Go to Solution.
The syntax would be
IF !(ISNULL([TIME]) THEN 0.27
ELSE NULL()
ENDIF
Remove the space in ENDIF