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
8 - Asteroid

Last one for today.

Highlighted
Alteryx Partner
Spoiler
2017-12-28_143415.png
Highlighted
Alteryx Certified Partner

Solution attached - thanks!

Highlighted
12 - Quasar

Nice simple one

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Challenge Completed

Highlighted
8 - Asteroid
Spoiler
I found this challenge super tricky and ended up getting the final result with a convoluted hack of a workflow.  Clearly, I need more Crosstab practice!
Highlighted
8 - Asteroid

Took me a while, spent a lot of time trying to get it to work correctly.  But good exercise for practicing Transpose/crosstab.  

Highlighted
Alteryx Certified Partner

Flipping tables like pancakes, it was a fun challenge! 🙂

Highlighted
8 - Asteroid

Always have trouble wrapping my brain around pivot tools, it's always good to practise them 🙂 

Highlighted
Alteryx Partner
Spoiler
Week 49.PNG