Be sure to review our Idea Submission Guidelines for more information!
Submission Guidelinescan 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.
Problem
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.