Calling all Racers for the Alteryx Grand Prix! It's time to rev your engines and race to the stage at Inspire! Sign up here.

Alteryx Connect Discussions

Find answers, ask questions, and share expertise about Alteryx Connect.

How to add a new column and sum several columns

5 - Atom

Hello. I hope somebody can help me:


I am trying to sum several columns in my file, there is no formula to do it.




Best regards.


11 - Bolide

@IsaacRamiro hi,

the best way I know is to:
- use "transform" tool -  this way you will have values in one column and column names in the other

- then you can sum the column with values

- and then "Cross Tab" it back to the original form
Please let me know if this helps.

5 - Atom

Awesome and interesting article. Great things you’ve always shared with us. Thanks. Just continue composing this kind of post.





Dollar General Survey

5 - Atom


You can do so by using the Formula tool, just make sure all are numeric with Select or else.

Example in the attached screenshot.

Have a good day!

17 - Castor

Hi @IsaacRamiro ,

You can achieve this output in 2 ways:

1. Easiest way would be to use formula tool and sum the columns. 

2. Second is little bit lengthy but a good learning way to achieve the output.

I have attached the workflow for both, you can use any of them.



Sapna Gupta