Formula repository for each version of Alteryx

Question

Hi All,

Just wanted to check if anyone knows if there is a document or repository that let's you know which formulas become obsolete when a new version of Alteryx is released?  For example, my company just upgraded from Alteryx Desktop 2021.4 to 2022.1 and formulas like IFNULL() no longer work.

I've looked at the release notes for 2022.1 and cannot see anything referencing this so thought I would ask here.  This would be a really useful resource to have so that we can prepare to swap formulas and tools where required before upgrading.

Thanks

ChrisTX · Answer

IFNULL isn't an Alteryx function.   Here's the function list for 2021.4:  https://help.alteryx.com/2021.4/Reference/Functions.htm?Highlight=functions

Is IFNULL part of an SQL query for a specific database?  Can you post an example?

Chris

alexnajm · Answer

IFNULL() is a third-party function that must've been downloaded previously and not moved with the upgrade - I answered a similar question on this here: Solved: IfNull still a function? - Alteryx Community