Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #138: World Series Wins

Highlighted
8 - Asteroid

Here is my solution.

 

Highlighted
8 - Asteroid

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

Highlighted
Alteryx Certified Partner

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

Highlighted
5 - 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.

 

 

Highlighted
8 - Asteroid

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

Highlighted
8 - Asteroid
Spoiler
Used concetanate year with seperator in CrossTab
Highlighted
8 - Asteroid

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

 

 

Highlighted
8 - Asteroid

Attached is my solution

Highlighted
Alteryx Certified Partner

31

Spoiler
Capture.PNG
Highlighted
8 - Asteroid