Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #128: Settle the Score

Highlighted
8 - 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
Highlighted
8 - Asteroid
 
Highlighted
12 - Quasar

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.

Highlighted
Alteryx
Alteryx

Regex!

 

Spoiler
clipboard_image_0.png
Sophia Fraticelli
Premium Support Advisor
Alteryx, Inc.
Highlighted
8 - Asteroid
Spoiler
128.png
Highlighted
Alteryx Alumni (Retired)

thanks, please advise with any tips 

Highlighted
Alteryx Alumni (Retired)
 
Highlighted
8 - 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.
Highlighted
8 - 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

 

Highlighted
8 - Asteroid
Spoiler
128.PNG