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 and repeat values

Goncal
5 - Atom

Hi,

 

I have sales data like this (each month in a separate column):

Goncal_1-1635867782806.png

 

 

And I needed like this:

 

Goncal_2-1635867840583.png

 

I need to repeat every single row for every month I have, and add the month next to it.

I think that once I have the months in a single column, matching the sales should be easy but I am struggling with the first part.

 

Thank you so much

 

3 REPLIES 3
Christina_H
14 - Magnetar

Use a Transpose tool, with Product Line, Brand family and SKU as key columns and all months as data columns.  The output should have all the months in the Name column and sales in the Value column, which you can rename in a Select tool.

Hi @Goncal 

 

You can use the Transpose tool and configure it, as attached.

christine_assaad_0-1635869165960.png

 

Goncal
5 - Atom

Thanks! this was easy! I am new to Alteryx and couldn't figure out the transpose tool

Labels