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

Took a slightly different approach and created a lookup table with Delimiter & Score Values

 

-Find and Replace score values to get delimiter inserted between scores

-Text to colums to split scores to rows by round

-Find and replace Score with actual value

-Modified case once score was brought in to sum total score per player per round

 

Spoiler
RL_Challenge_128.png
Asteroid
 
Asteroid

It took me a while to figure out how the scoring worked, once I figured that out I was able to work the enclosed solution.

Moderator
Moderator

Regex!

 

Spoiler
clipboard_image_0.png
Sophia Fraticelli
Premium Support Advisor
Alteryx, Inc.
Asteroid
Spoiler
128.png
Alteryx
Alteryx

thanks, please advise with any tips 

Moderator
Moderator
 
Asteroid
My solution. I presume there was a better way using Reg Ex, but I got it to work using Join with a static list for identifying which were uppercase/lowercase.
Asteroid

I found this challenge a little difficult.. and I also end up using two tools that I rarely use - RegEx and Multi-Field Formula... anyway got to the answer finally!

 

Spoiler
128 pic.png

 

Asteroid
Spoiler
128.PNG