Alteryx Designer Discussions

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

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

 

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 .

 

 

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