Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #128: Settle the Score

rslopez2
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
Ellie_P
8 - Asteroid
 
wwatson
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.

SophiaF
Alteryx
Alteryx

Regex!

 

Spoiler
clipboard_image_0.png
Sophia Fraticelli
Senior Solutions Architect
Alteryx, Inc.
garthn555
8 - Asteroid
Spoiler
128.png
AlexSa
Alteryx Alumni (Retired)

thanks, please advise with any tips 

PaulN
Alteryx Alumni (Retired)
 
mcultrera
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.
Deevi
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

 

fmeo
8 - Asteroid
Spoiler
128.PNG