Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Is it possible to sum all existing fields without using summarize tool?

calvinwong
7 - Meteor

Hi,

 

I'm trying to sum all the data in every existing columns. However, the summarize tool will need to predefine the field header. What if my input data will change every time (meaning instead of having 5 columns, i might have 6 columns next time). So instead of going back to add the new column in the summarize tool, is there a way to just sum all existing fields?

 

Please let me know if you would like an example?

 

Thank you for all of your help in advance.

 

Thanks,

 

2 REPLIES 2
estherb47
15 - Aurora
15 - Aurora

Hi @calvinwong 

You can use the Transpose tool to get all of the columns into one column, and then a Summarize tool that just adds up all of the values in the new column.

 

Cheers!

Esther

calvinwong
7 - Meteor

Ahhh. That works. I can just group by the Name after. Okay. Thank you so much!! I kept thinking if I need to use the Multi Field Formula. But this works. :D

Labels