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 #138: World Series Wins

mgaronson
11 - Bolide
Spoiler
Spoiler
mgaronson_0-1686830704690.png

No internet available, so I had to double up (in formula and Regex tool) on Regex as I could not figure out how to do in one step.

tristank
11 - Bolide

Fun challenge! The only thing on mine that is different is I didn't put the % in the winning percentage column because I wanted to keep them as numbers for future workflows. A data analyst would thank me 😜

 

Spoiler
138.png

 

caltang
17 - Castor
17 - Castor

Done!

 

Spoiler
Screenshot 2023-07-07 103358.png

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
olga_strubbe
11 - Bolide

A neat challenge, thank you, @ChristineB!  Tricky part I did not realize that some teams had trailing and leading white space, as the column header indicator was green (100% good for the column values).  Once I cleaned that up, my results tied and there were not duplicate teams based on white space ;)

I am still not able to post the spoiler - waiting on support ticket resolution.  See my solution attached. 

mithily
8 - Asteroid
Spoiler
regex and summarize
AndreeaS
8 - Asteroid
Spoiler
Screenshot 2023-07-16 212420.png

 

aiahwieder
8 - Asteroid

As a Mets fan, this was tough.

Dani_Lin
8 - Asteroid

solved

Computernerd
8 - Asteroid

Mine is nothing like the solution.

DaisukeTsuchiya
13 - Pulsar
Spoiler
スクリーンショット 2023-08-22 192717.jpg