This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!
Be sure to review our Idea Submission Guidelines for more information!
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.
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.
thanks for your feedback @Pang_Hee_Choy, that would certainly be a robust feature!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.