Challenge #138: World Series Wins

[ANorbs_dup_4]

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]

Attached my solution.

Best regards,

[Verakso]

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

Spoiler

In 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]

Spoiler

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

[Ukashi]

My solution below, 

Spoiler

[ch12345]

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

Spoiler

[Niklas]

Spoiler

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]

Here's my solution

[DavidP]

Here's my solution