In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Transform

Kjaer
8 - Asteroid

I have this format

 

Kjaer_0-1630507646400.png

 

and want this one

 

Kjaer_2-1630507938579.png

Can anyone help me?

5 REPLIES 5
Luke_C
17 - Castor
17 - Castor

Hi @Kjaer 

 

You can use the crosstab tool:

 

Luke_C_0-1630508123148.png

 

 

atcodedog05
22 - Nova
22 - Nova

Hi @Kjaer 

 

You can use crosstab like below

 

atcodedog05_0-1630508163674.png

 

Here is a resource on the same https://community.alteryx.com/t5/Interactive-Lessons/Changing-Data-Layouts/ta-p/82876 

 

Hope this helps : )

 

surajmthomas
8 - Asteroid

surajmthomas_0-1630508412716.png

 

The cross tab tool should help you transform your data structure into the desired output

Kjaer
8 - Asteroid

Perfect. My problem is solved.

Thanks

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Kjaer 

If the response helps please don't forget to mark it as solution.

Cheers and have a nice day!

Labels
Top Solution Authors