The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop 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) 

 

Pang_Hee_Choy_6-1634812704066.png

 

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. 

 

Pang_Hee_Choy_1-1634811729918.png

 

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

Pang_Hee_Choy_2-1634811746685.png

 

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

Pang_Hee_Choy_3-1634811821262.png

 

suggestion :

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

Pang_Hee_Choy_5-1634812692162.png

 

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

 

 

 

 

2 Comments
CristonS
Alteryx Alumni (Retired)

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

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