Alteryx Designer

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

Row wise summation of dynamic columns

Highlighted
8 - Asteroid

I need to do a row wise summation of a few columns that are dynamic. The ones highlighted in yellow needs to be used for summing the values in these columns. These columns are dynamic and hence, i cannot write a formula using all these columns. How can i get the desired results like how i have showed in the output?

 

Input:

Capture.PNG

 

Highlighted
Alteryx
Alteryx

Hi @hash_89 

 

Below I've attached the solution to this issue.

 

It will involve transposing the data and aggreating it before joining back together.

 

Let me know if it works for you.

 

Capture.PNG

Highlighted
11 - Bolide

Hi @hash_89 -

You could try using a transpose tool grouping by name, class, year and then a cross tab grouping by name, class, year with your new 'names' as the columns. Then add a total column from there. Example below & attached.

DynamicColumnsTotal.PNG

Labels