Challenge #138: World Series Wins

A solution to Challenge #137 has been posted HERE!

Aside from completing a Weekly Challenge, there's nothing more thrilling than World Series baseball! This weeks' challenge asks you to analyze data on previous World Series match-ups. Use the provided data to determine each team's number of World Series appearances, list the years in which each team won the World Series, and calculate each team's winning percentage based on their World Series appearances.

The play by play...

challenge_138_start_file.yxmd

challenge_138_solution.yxmd

Parse

Join

Preparation

Advanced

Data Analysis

Data Preparation

Transform

Basic

Accepted answers

All comments

Paul-Evans

Here's my solution:

challenge_138_solution_Probley.yxmd

grodge13

My solution attached. Could be better if I used regex.

challenge_138_soltuion_GR.yxmd

neilgallen

Spoiler

This is ugly and I hate it so much, but it gets there.

Spoiler

challenge_138_NGA Solution.yxmd

patrick_digan

I went ahead and penciled boston in for the 2018 World Series win

Spoiler

challenge_138_start_file.yxmd

CHarrison

My solution

Challenge 138.yxmd

AGoyal

My solution.

challenge_138_start_file.yxmd

Saravanakumar

Here's my solution

challenge_138_start_file_SS.yxmd

kat

Waiting for the day that regex comes naturally.. For now it'll have to be regex101.com

Spoiler

Challenge #138.yxmd

TianyueYang

My first attempt to weekly challenge

challenge_138_start_file.yxmd

NicoleJohnson

My solution!

Spoiler

Cheers,

challenge_138_NicoleJohnson.yxmd

jasperlch

Solution attached

challenge_138_JL.yxmd

Mac

Great topic for the challenge!

challenge_138_Mac.yxmd

Wouter

My solution:

Spoiler

challenge_138_solution_WK.yxmd

Lbunce

First time attempting one of these, but managed to do it in the end.

Spoiler

challenge_138_solution_LB.yxmd

Ladarthure

My solution! Fun one!

challenge_138_start_file.yxmd

StevenBetts

Here's my solution. Enjoyed this one

Spoiler

challenge_138_start_file_SMB.yxmd

ponraj

Here is my solution.

Spoiler

Workflow

challenge_138_solution.yxmd

kcgreen

This took more tools than expected.

Spoiler

challenge_138_World_Series.yxmd

KMiller

I really need to beef up my regex skills, tried very hard to get it all into one expression but just couldn't figure it out.

KM challenge_138_solution.yxmd

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.

challenge_138.yxmd

BENOIT_RAFFIN

Attached my solution.

Best regards,

Weekly_Challenge_138_BRP.yxmd

Verakso

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

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,