IfNull still a function?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I just updated Alteryx Designer to 2023.1.1.123 from the last 2022 version and now my workflows with IfNull() no longer recognize IfNull() as a function. Did that function go away?
Solved! Go to Solution.
- Labels:
- Bug
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have 2022.3 installed and I don't see an IfNull() function. You can do IF IsNull() or IF [column]=Null() if that helps!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Macon you can also do something like:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thanks! I'm definitely re-working my ifnull() statements to be if Isnull() then foo else bar endif. but IfNull(foo,bar) is SUPER handy and I'm bummed it went away.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
but I'm also super interested to know from any offical Alteryx peeps if it was deprecated or not.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Where do you see ifnull on 2022.3? Can you send a screenshot?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
huh. maybe I downloaded it as a 3rd party built function?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thanks @alexnajm! I see now that it was part of a set of utility functions that I'd downloaded and when I installed the new version (in a new place) it didn't have access to those utilities.
https://github.com/jdunkerley/AlteryxFormulaAddOns/blob/master/README.md
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
