In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Add Multiple Columns into single column

sshind58
5 - Atom

Hello Dears,

 

I have columns with c1,c2,c3,c4,c5 headers and I want to add values from them in single column "Sum C". Currently I am using formula tool, but for that I am entering all formula manually like c1+c2+c3+c4.. I have 30-40 columns and also need to add many such Sum columns. Can anyone please suggest shortcut for this?

3 REPLIES 3
alexnajm
18 - Pollux
18 - Pollux

Transpose those columns and CrossTab them back (with Sum and Total selected) should do the trick!

alexnajm
18 - Pollux
18 - Pollux

Roland's solution here should work decently well: Solved: Adding totals to dynamic table - Alteryx Community

sshind58
5 - Atom

Thank you...!!

Labels
Top Solution Authors