Weekly Challenge

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #49: Reformatting Transactional Data

Highlighted
Alteryx Certified Partner

Not elegant or optimized, but got an answer quick...

Highlighted
14 - Magnetar
14 - Magnetar

My solution. Oh, Transpose & Cross-Tab, whatever did I do before I figured out how to use you...

 

Spoiler
WeeklyChallenge49.JPG

 

Highlighted
14 - Magnetar
14 - Magnetar

Same solution as many. Split into 2 streams, one for the data, one for the key rows/headers.

Highlighted
Alteryx Certified Partner

Solution:

 

Spoiler
Weekly Challenge 49.png
Highlighted
Alteryx Partner
 
Highlighted
8 - Asteroid

Happy to see my solutions are starting to look like everyone else's

Highlighted
Alteryx Certified Partner

Solution attached

Highlighted
Alteryx Certified Partner

Here's my very long and clumsy solution! Not sure why but I couldn't get my head around this one.

 

Spoiler
challenge_49.png
Highlighted
16 - Nebula
16 - Nebula
Spoiler
Capture.PNG
Highlighted
Alteryx Certified Partner
Spoiler



challenge49.PNG

Spent far too long messing around with those pivots trying all combinations of all the transform tools and finally did it in a fiddly way.... Will refer to how everyone else has done it and get my head around how to pivot data properly!