community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #138: World Series Wins

Meteor

Here is my solution.

 

Asteroid

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

Alteryx Certified Partner

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

Highlighted
Atom

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.

 

 

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

Asteroid
Spoiler
Used concetanate year with seperator in CrossTab
Asteroid

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

 

 

Asteroid

Attached is my solution

Alteryx Certified Partner

31

Spoiler
Capture.PNG