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.
We are aware of an issue with the Search bar. Please use Advanced search for the time being while we troubleshoot. Thanks for your patience as we work on improving the community!

Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

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

Submit Feedback

Challenge #138: World Series Wins

ANorbs
5 - Atom

My solution definitely could be condensed into half of the total number of tools I used, but I like visualizing everything step by step, plus I am still learning, having only started a job where I use Alteryx daily last week.

BENOIT_RAFFIN
6 - Meteoroid

Attached my solution.

Best regards,

 

Verakso
10 - Fireball

It took some iterations, and just shows, that there is many ways to the same result.

 

 

Spoiler
2018-10-24 00_12_30-Alteryx Designer x64 - challenge_138_verakso.yxmd_.pngIn order to concatenate the Winning Years, I could not get the interface in the Designer to work, but I have enabled the XML button, so I did go in and change the settings of the component, and then it worked,

Until next week
//Thomas

George_Walker
8 - Asteroid
Spoiler
Capture.PNG

I feel like this is a very inelegant solution, but there we go

Ukashi
8 - Asteroid

My solution below, 

 

Spoiler
image.png
ch12345
7 - Meteor

It's not the cleanest solution, and I was trying to avoid joins and unions, but it works!

 

Spoiler
Capture.PNG
Niklas
8 - Asteroid

 

Spoiler
138_solution_NE.PNG

Felt a bit like I used the Data Cleansing tool as a crutch for sub-optimal regex on this one.

 

It works, but I probably need to spend some time comparing my RegEx to others in this thread. Probably some optimisation to be had there.

 

RamanMahesh
5 - Atom

Here's my solution

sprodger
8 - Asteroid
 
DavidP
16 - Nebula
16 - Nebula

Here's my solution