ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #49: Reformatting Transactional Data

PrivateStorm
8 - Asteroid

My solution is attached.

Inactive User
Not applicable
 
TravisR
Alteryx Alumni (Retired)
Spoiler
Simple Transpose then Crosstab then Join
Vinutha
8 - Asteroid

I struggle with crosstab and transpose

jeniferpeden
7 - Meteor
 
OllieClarke
16 - Nebula
16 - Nebula

That took longer than I thought...

Spoiler
Challenge 49.PNG
gmartin
7 - Meteor

A different solution, but a solution nonetheless.

 

Here is my solution!

 

Spoiler
challenge_49_gm_image.PNG
Walsh67
8 - Asteroid

My solution...

Inactive User
Not applicable
Spoiler
alteryx2.PNG
lainecaruzca
8 - Asteroid

Here is my solution