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.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #128: Settle the Score

Asteroid

#128

Alteryx Partner

pretty weird scoring method ngl

Spoiler
Challenge 128.PNG

Really great exercise to learn for beginners, thank you! 

 

Spoiler
clipboard_image_1.png
Meteoroid

My solution leveraged regular expressions, transform tools, and dynamic rename

Alteryx Partner

Fun challenge! 

Asteroid

My solution attached

Spoiler
Solution_Weekly_Challenge128.png

Here's my solution!

Alteryx Partner

Go Team E!

 

Spoiler
Saved by REGEX_CountMatches()!
Still not good at Cross_Tabs and Transposes...

Process
- REGEX_Countmatches to subtract sum of Capital letters from Lower Case letters
- A pointless Transpose....
- Clean-up fields
- Transpose and Crosstab to finally get my records and fields straight (poorly done)
- Marquee Crew's Add Totals tool to get total per player
- Cleanup

MySolution.PNG
Alteryx
Alteryx

 

Spoiler

 

 

Alteryx Partner
Spoiler
clipboard_image_1.png