Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

a formula tool that can refer to multiple field and dynamic field

can we have a formula tool to refer multiple field (especially dynamic as well) 




i KNOWN we can use transpose and crosstab tool. but it silly to do one thing with two tool.




To sum all the fields in the file. so now is A-D. 




I can use formula tool to do it. easy. But, what if fields add / delete frequently?



Now, it sum A-E, what if G-F tomorrow, and B-Z after tomorrow, i do not want to update workflow every time.



suggestion :

I hope we have a tool that similar to multiple field tool, but it output to a new field only.



I KNOWN SUM() is not alteryx function but just an example. we can expand further other formula for string and date.





Alteryx Alumni (Retired)

thanks for your feedback @Pang_Hee_Choy, that would certainly be a robust feature!

Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes