Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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