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

Nic_Morales
Alteryx
Alteryx

Solution attached. 

Blake
12 - Quasar
Spoiler
128.jpg
danicahui
8 - Asteroid
Spoiler
Challenge 128 2019-12-05.jpg
sachinw
8 - Asteroid

My Solution:

apabonok
8 - Asteroid

Hi! This is my solution.

 

challenge_128_apabonok_spoiler.png

 

Rags1982
10 - Fireball
 
echuong1
Alteryx Alumni (Retired)

Love the CREW macros!

 

Spoiler
echuong1_0-1575657625127.png
sonyakasenkramer
8 - Asteroid

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

Spoiler
sonyakasenkramer_0-1575918960240.png
Hjardine
8 - 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!

nivi_s
8 - Asteroid

Solved!

 

Spoiler
nivi_s_0-1577502668186.png

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