Free Trial

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

Calliecobbs
8 - Asteroid

Here is my solution.

 

AmNotARobot
8 - Asteroid

Happy with learning experience, less pleased with results (as in too many tools use). My results joined perfectly to expected results.

DanHare
11 - Bolide

I don't like Regex, too much like code not data driven, but would reduce the number of tools !

stlbw
6 - Meteoroid

Here's my solution, for my first weekly challenge! I had to check out some of the RegEx that other folks were doing, since my text to columns approach kept leaving me with duplicate team names.

 

 

Brian_Stoffel
8 - Asteroid

I took the long route but I documented as I traveled.

klyuka
8 - Asteroid
Spoiler
Used concetanate year with seperator in CrossTab
Shaun_Rheeder
8 - Asteroid

It's not pretty but it got the job done.

 

 

Etienne
8 - Asteroid

Attached is my solution

LordNeilLord
15 - Aurora

31

Spoiler
Capture.PNG
piotrzawistowski
8 - Asteroid