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

Highlighted
6 - Meteoroid

Attached my solution.

Best regards,

 

Highlighted
Alteryx Certified Partner

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

Highlighted
Alteryx Partner
Spoiler
Capture.PNG

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

Highlighted
Alteryx Partner

My solution below, 

 

Spoiler
image.png
Highlighted
7 - Meteor

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

 

Spoiler
Capture.PNG
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.

 

Highlighted
5 - Atom

Here's my solution

Highlighted
8 - Asteroid
 
Highlighted
15 - Aurora

Here's my solution