We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Transform data

D_Y
8 - Asteroid

Hi community

 

I have a dataset that looks like this: 

D_Y_0-1636566549566.png

 

For dashboarding purposes, I am trying to get it to become like this:

D_Y_1-1636566573115.png

 

I have tried using the Transpose tool but am having trouble performing the exact steps needed to get there.

I attached the sample file of the two screenshots. 

 

Thanks in advance for any help! 

 

3 REPLIES 3
chuckleswk
11 - Bolide

The attached flow should get you the output that you're looking for. You have to do several different transposes to get your desired output.

Capture.PNG

D_Y
8 - Asteroid

Thanks for your help! This is exactly what I needed! And wow, definitely a couple more steps/tools than I thought. 

chuckleswk
11 - Bolide

Glad I was able to help you out! That was the easiest way for me to build it out. It may be possible to do it in fewer steps....but this was the fastest way to get you the results you were looking for.

Labels
Top Solution Authors