community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

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

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,

 

Pulsar

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

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