Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Andy Uttley, Alteryx ACE, makes music with Alteryx | Math + Music
SOLVED

New Total Column, sum of values across many columns per row

Highlighted
7 - Meteor

Hi all, 

 

This is probably such a simple problem, but besides a very manual formula, I am having a hard time figuring this out. If I have:

 

IDCOL1COL2COL3COL4
1230010
4561301
7890501

 

And want:

 

IDCOL1COL2COL3COL4Total
12300101
4561301

5

7890501

6

 

 

What tool do I use to do this?  I have more than a 100 columns which need to by summarized in this way, so a manual [col1]+[col2}..etc. formula would be a nightmare!  Thanks!!

 

JP

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
Firstly pivot your data, with the line ID acting as a key field and your value fields acting as your data fields.

Secondly summerize your data, grouping by the line ID and returning the SUM value.

Then use the join tool to bring your aggregated data inline with your oriinal data stream, using the Line ID field.

Ben
Highlighted
7 - Meteor

Ben, 

 

Works awesome! Thanks for helping me make sense of this problem.  Now that I see it in action, it makes sense.  Much appreciated!

 

JP

Highlighted
8 - Asteroid

I'm just posting a file and screenshot w/ the solution @BenMoss described.

 

Capture.PNG

Labels