community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #63: Data Preperation Using Pivot Tools

Alteryx Certified Partner

Lots of RegEx practice here..

 

Spoiler
Weekly Challenge 63.png
Alteryx Certified Partner

Here's my solution.  Slightly disagree with the posted solution -- surely "Week of" should be the start not end of the week?

 

Spoiler
challenge-63.png
Alteryx Certified Partner

Solution Attached

Fireball

Um i think the dates in the solution file are off, but the numbers are the same? anyways not the most compact or pretty thing but does the job and should be dynamic for more columns

Bolide
Bolide

Getting more confident with transpose and crosstab all the time.

Asteroid

Solution attached.

Alteryx Certified Partner

Solution attached. Pretty concise.

 

Spoiler
challenge_63 - Snip.PNG
Quasar

Solution attached.

Alteryx Certified Partner

Challenge Completed

Alteryx Partner

I think from all my workflows so far, this is the one with the highest ratio of dynamic renaming to other tools...

Spoiler
63.png