We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Connect Discussions

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

How to add a new column and sum several columns

IsaacRamiro
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.

 

IsaacRamiro_0-1650985326553.png

 

Best regards.

Ramiro.

4 REPLIES 4
JarekSkudrzyk
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.

HairyPotato
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

shaharsar
5 - Atom

Hi,

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!

grazitti_sapna
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.

 

Thanks!!

Sapna Gupta