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.

Challenge #138: World Series Wins

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.

Attached my solution.

Best regards,

 

Alteryx 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

Alteryx Partner
Spoiler
Capture.PNG

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

Alteryx Partner

My solution below, 

 

Spoiler
image.png
Meteor

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

 

Spoiler
Capture.PNG
Meteor

 

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.

 

Here's my solution

Meteoroid
 
Quasar

Here's my solution