Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Add a certain number of columns to a new column, for every column

5 - Atom

Thank you for your time and help in advance

 

my data is

 

 

NameJanuary

Feb

MarchAprilMayJune
John

15

52331313
Smith107661156546456
Noah691151546748
Susan211295449877

 

What Ia m trying to do is 

 

NameJanuary+Feb+MarchFeb+March+AprilMarch+April+MaySo on....
John15+5+25+2+332+33+13 
Smith10+7+667+66+115666+1156+546 
Noah6+9+1159+115+15115+15+46 
Susan2+1+1291+129+54129+54+498 

 

 

In an automated way as there will be a column added every month and I hope the workflow can pick it up without hard-coding in formula icon

Thanks

 

Highlighted
12 - Quasar

Hi  @Sherif1 ,

Multi row , transpose , cross tab and dynamic rename  can get expected results.

If you are looking for  sum  in values  change  the values to numeric  and  formula in multi row .

 

 

Highlighted
Alteryx
Alteryx

Hey Sherif,

 

Attached a potential solution to your challenge.. I hope it helps and gives you an idea on how to approach it.

 

I basically Transposed your data so that you keep looking at your columns dynamically

Used 3 multi-row formulas, one is to create the labels, one is to generate the number you're looking for and one is to keep the order you already have

then used a cross-tab to have your data in different columns as you had before... added a dynamic rename just to rename columns.

 

This workflow should work fine as you add new rows and columns to your data

 

Hope this helps.

Cheers,

Mo

Labels