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

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!)