Alteryx single function list

Question

I was searching for the easiest way to extract a value from a semicolon separated list within a bigger formula. I know there are about 50 different ways to do this in Alteryx.

I came across this list of string functions through Google

Current designer string functions

When GETPART was not recognized in my 2021.4 version, I discovered that is "what's new" list in the most current version of Designer. Finding information like this, and then figuring out if it's still valid, old no longer valuable, or too new for my version has always seemed somewhat chaotic on the Alteryx website.

Is there a "single list" published anywhere of every Alteryx function available, and what version of Alteryx it was released in?

KGT · Answer

No problem, I already knew what to search to then be able to follow links and get there, so happy to help. There would be some function lists on the community somewhere from around then as well, but no idea whether they'll be the exact version.

Understand on the update schedule. In a lot of orgs, Alteryx is owned by the business, or at least updates are coordinated with LOB users, and so it commonly doesn't get upgraded as regularly.

Functions shouldn't really behave differently in Formula/Filter, but I won't say that it can't happen. You will get differences between Filter/Join or some other combos. It's normally to do with case sensitivity.

ColinG · Answer

Thanks, this is a particularly handy view of the actual functions available in my version. The formatting is a little rough to quickly scan without going crosseyed, but it's serviceable. I hadn't been able to find this with Google or other breadcrumbs from other Alteryx articles.

I somehow have a habit of finding functions that aren't available in the version I'm on, or functions that behave differently whether they are used in a filter tool or a formula tool, or functions that have the same name in other languages but behave differently in Alteryx, and it always takes longer than it should to figure out if it's a me or an Alteryx problem.

While I can run more recent versions of Designer, almost every workflow I do needs to be scheduled on Server, and unfortunately I have no control on when my company is able to upgrade. So regardless on whether a version is out of support, if our company is still on that Server version, it's what I have to use.

KGT · Answer

I'll add to the @alexnajm answer to say that, it is not often that extra formulas get updated. Hence why an actual list with the versions has not been produced.

I don't know the exact numbers, but I think there was a few added in 2018 and since then there may be 3-4 versions out of the 20-odd that had a formula updated/changed.

As 2021.4 is an "Out of Support" version, the help has not been updated to the new format. But can still be found here: https://help.alteryx.com/20214/en/designer.html

With the list of functions here: https://help.alteryx.com/archive/20214/designer/Reference/Functions.htm