Formula Tool - Number the Number of Expressions

[Drew502]

In one of the recent releases, Alteryx enhanced the error message when there is an error within the Formula tool to display the error and the formula expression number.  

Example: 

Error: Formula (3): Parse Error at char(0): Unknown variable "TEST" (Expression #2)

My suggestion would be to label the different expressions within the formula tool with expression numbers.   And/or code the expression name when there is an error message.

[jrpaul]

I second this.  The error message isn't helpful if I have to count through 50+ formulas to find the right one with the error.  Adding expression numbers in the Configuration window would be a big help.

[jsdeter]

I third this !!  Counting expressions is not productive.  

[patrick_digan]

Simple fix!

[NicoleJ]

Designer Product team is investigating inclusion of this idea in conjunction with other requested feature updates for the Formula tool... Stay tuned!

NJ

[NicoleJ]

Stay tuned! Expression ID number is making a comeback soon :) 

NJ

[NicoleJ]

Expression numbers have been added to the Formula tool as of Designer version 2022.3! You can now quickly identify which expression has the error based on any messages received. Happy Alteryx-ing!

[Varad_Paranjape]

Hi, I am confused with this bit of information here. I have quite a few expressions within the same formula and they are not numbered. The page here - https://help.alteryx.com/20231/designer/formula-tool says that each expression gets numbered automatically ? Is there a manual process to number them ? 

[NicoleJ]

@Varad_Paranjape Can you confirm which version of Designer you are on? This feature with expression numbering was introduced in 22.3, so if you're on a prior version those expressions will not be numbered.

[Varad_Paranjape]

Hi @nicoleJ I am on Version: 2021.4.2.02731

[NicoleJ]

Upgrading to at least version 22.3 will give you access to that new functionality then! We have release additional version 23.1 since then as well, with more great new features - check out our Release Notes to find out more about the options available in each new Designer release :) Thanks!

https://help.alteryx.com/release-notes/designer/designer-20223-release-notes

https://help.alteryx.com/release-notes/designer/designer-20231-release-notes