Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #128: Settle the Score

Alteryx
Alteryx

Solution attached. 

Highlighted
Alteryx Partner
Spoiler
128.jpg
Highlighted
Asteroid
Spoiler
Challenge 128 2019-12-05.jpg
Highlighted
Asteroid

My Solution:

Highlighted
Asteroid

Hi! This is my solution.

 

challenge_128_apabonok_spoiler.png

 

Highlighted
Asteroid
 
Highlighted
Alteryx
Alteryx

Love the CREW macros!

 

Spoiler
echuong1_0-1575657625127.png
Highlighted

First time using RegEx. Not as scary as I thought!

Spoiler
sonyakasenkramer_0-1575918960240.png
Highlighted
Asteroid
Spoiler
Hjardine_0-1577480522554.png



I did kind of a backward way of getting to the answer, but got to it. I regex'd to tokenize each letter in the score. Then i summarized and counted each occurrence of uppercase and lowercase letter. From there I split up upper and lower case letters with a filter and then assigned numeric scores to each using the formula tool. I then cleansed the uppercase to lowercase letters so i could join the scores to add them. I then added each score for each letter by using the summarize tool and found that letter E won with a score of 8!

Highlighted
Asteroid

Solved!

 

Spoiler
nivi_s_0-1577502668186.png

(Just hit 75 with this challenge! 120 more to go, as of now!)