community
cancel
Showing results for 
Search instead for 
Did you mean: 

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #63: Data Preperation Using Pivot Tools

Alteryx Certified Partner
 
Asteroid

PFA my solution

Asteroid
Spoiler
2019-09-26 13_04_01-Greenshot.pngLots of fun with the Transform and Parse tools
Alteryx
Alteryx

Long challenge, here is my solution.

Asteroid
 
Alteryx
Alteryx
Spoiler
63 workflow.jpg
Asteroid

I'll be honest, this one was a little humbling. Thought it would be quicker, but like someone before me said, had to beat this one into submission. I suspect that though I am comfortable with pivot tools, there is a wall in my understanding that's keeping me from really flexing them as much as possible. They're obviously very powerful but require some good practice to really get the sequence of pivoting right for more advanced/tricky challenges.

 

Spoiler
challenge_63_solution_justindavis.PNG

Solution attached

Alteryx Partner

My solution

 

Spoiler
challenge_63_RODO_Solution.png
Meteor

Had to follow along the solution quite a bit to get there. Not a easy to solve problem. Going to do it again without the solution tomorrow.