IfNull still a function?

[Macon]

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?

[alexnajm]

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!

[rzdodson]

@Macon you can also do something like:

[Macon]

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.

[Macon]

but I'm also super interested to know from any offical Alteryx peeps if it was deprecated or not.  

[alexnajm]

Where do you see ifnull on 2022.3? Can you send a screenshot?

[Macon]

huh.  maybe I downloaded it as a 3rd party built function?

[Macon · Accepted solution]

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

[Rana_Kareem · Accepted solution]

Hi @Macon ..

You can use this expression:

IIF(IsNull([Field Name]), x, y)