Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Adding up columns for sum

nikhilg19
7 - 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)  ?

5 REPLIES 5
danilang
19 - Altair
19 - Altair

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

 

Thableaus
17 - Castor
17 - Castor

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,

Thableaus
17 - Castor
17 - Castor

Right at the same time, @danilang!

 

Cheers,

danilang
19 - Altair
19 - Altair

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

Thableaus
17 - Castor
17 - Castor

@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