SOLVED
Creating an IF Statement in the Formula Tool
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Andrew_Seaman
6 - Meteoroid
‎03-26-2020
03:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Common Use Cases
1 REPLY 1
15 - Aurora
‎03-26-2020
03:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The syntax would be
IF !(ISNULL([TIME]) THEN 0.27
ELSE NULL()
ENDIF
Remove the space in ENDIF
![](/skins/images/9780FA8738778E76CAA545EFAA4CDA4D/responsive_peak/images/icon_anonymous_message.png)