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

Help formatting or unpivoting data

MaddSage
5 - Atom

I am bringing in data from a sheet in excel and I need to reformat it into better columns and rows in Alteryx as part of a larger workflow. I think it would be considered unpivoting columns, but I'm not familiar with how to do this in Alteryx.

 

I have data that looks like this:

 

 Forecasted year202120212021
 Forecasted monthSeptemberOctoberNovember
     
Loc NameProd mixCostCostCost
Loc AAverage100200300
Loc A10101201301
Loc A16102202302
Loc BAverage103203303
Loc B7104204304
Loc B12105205305

 

But I want it to look like this:

 

Loc NameProd mixForecasted YearForecasted MonthCost
Loc AAverage2021September100
Loc AAverage2021October200
Loc AAverage2021November300
Loc A102021September101
Loc A102021October201
Loc A102021November301
Loc A162021September102
Loc A162021October202
Loc A162021November302

 

I'm not sure how to get the date fields into the rows. I feel like this shouldn't be too difficult, but I am completely baffled! I've attached the sample input data. Thanks for the help!

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @MaddSage 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1634310675621.png

 

Hope this helps : )

 

MaddSage
5 - Atom

That works perfectly, thank you so much!

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @MaddSage 

Cheers and have a nice day!

Labels