community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!
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.

Challenge #36: Data Cleansing Extract Authors

Asteroid

and another

Alteryx Partner

Monochrome until summarize

Spoiler
36.png

 

Asteroid

Challenge Completed

Asteroid

I still stumble with the Cross Tab and Multi-Rows Formula tools.  I had to pull up some of my old completed challenges for a refresher on how those two work.  

Spoiler

 

 

challenge36.JPG

 

Asteroid

Love a bit of parsing :)

Alteryx Partner
Spoiler
Capture.PNG
Asteroid

Solution attached

Alteryx Certified Partner

Good multi-row challenge!

Alteryx Certified Partner
 
Alteryx Certified Partner

Follow my solution attached...