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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Adding up columns for sum

Highlighted
Meteor

Hi,

It is dynamic that today I may receive 4 columns; tomorrow I may receive 5 columns.

I want a new column which shows addition of these all coulmns

 

Is it possible to use formula something like (A1:A1)  ?

Magnetar

Hi @nikhilg19 

 

In this case you want to add a record id, transpose your data, sum grouping by recordID and join back to the original data set

 

Workflow

WF.png

 

Results for 4 columns

4 columns.png

 

Results for 5 columns

5 columns.png

 

Dan

 

Alteryx Certified Partner
Alteryx Certified Partner

Hi @nikhilg19 

 

Record ID, Transpose (Checking Dynamic and Unknown Fields) and Summarize Tool, then bring it back to your dataset using Cross-Tab and a Join Tool.

 

Cheers,

Alteryx Certified Partner
Alteryx Certified Partner

Right at the same time, @danilang!

 

Cheers,

Magnetar

Hi @Thableaus 

 

We seems to both be active around the same time.  Are you based in Europe?  I'm in Canada but I start early.

 

Dan

Alteryx Certified Partner
Alteryx Certified Partner

@danilang 

 

Cool! I'm in Brazil. I think it's a 2 hour difference from Toronto (not so sure what your time zone is in Canada).


Cheers,

Labels