Question about matching?

[gradyg19]

Hi! I'm still in the process of learning how to fully utilize Alteryx and I'm really stumped on something. I have 2 columns: one contains a list of years and the other contains a list of baseball teams.

Baseball Team          Year
BostonAmericans      1903
NewYorkGiants          1905
ChicagoWhiteSox      1906
ChicagoCubs             1907
ChicagoCubs             1908
PittsburghPirates       1909
PhiladelphiaAthletics 1910
PhiladelphiaAthletics 1911

The year represents the year in which the baseball team on the left won the World Series. The problem is that there are multiple winning years for some teams.

This is how I want it to look:

Baseball Team          Year
BostonAmericans      1903
NewYorkGiants          1905
ChicagoWhiteSox      1906
ChicagoCubs             1907, 1908
PittsburghPirates       1909
PhiladelphiaAthletics 1910, 1911

Any ideas? Thanks!

[AngelosPachis · Accepted solution]

Hi @gradyg19,

I would suggest to : 

1) Convert your years into a string field, if not already, via using a select tool

2) Use a summarise tool, group by the winning team and concatenate the year using "," as a delimiter

Hope that helps

Cheers

[gradyg19]

Perfect!! Thank you so much for your reply! @AngelosPachis

[AngelosPachis]

No worries @gradyg19, you 're welcome! Have a great day