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

Transpose Multiple Column and add new column

Abhishek_Gupta
6 - Meteoroid

Hi 

 

I have a table containing data for multiple periods. My task is to transpose the period data into rows and add a new column which defines what period data is it. Below is the example for the same.

 

Input Table

 

CategoryBrandRevenue 13 WeekQty 13 WeekRevenue 26 WeekQty 26 Week
C1B133.2344546
C1B2232040.334

 

Output Table

 

CategoryBrandRevenueQtyPeriod
C1B133.23413 Weeks
C1B2232013 Weeks               
C1B1454626 Weeks
C1B240.33426 Weeks

 

Can anyone please suggest if this is even possible in Alteryx?

2 REPLIES 2
MSalvage
11 - Bolide

@Abhishek_Gupta,

 

Definitely possible. I have attached a workflow that gets this done. Might have to fiddle with the Regex for your real data.

 

Hope this helps,

Msalvage

Abhishek_Gupta
6 - Meteoroid

Wowww..Thats a cool solution...some minor tweaks were required to fit in my actual data...Thank you very much

Labels