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

ANorbs_dup_4
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
7 - Meteor

Attached my solution.

Best regards,

 

Verakso
11 - Bolide

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
17 - Castor
17 - Castor

Here's my solution