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!
Solved! Go to 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
Perfect!! Thank you so much for your reply! @AngelosPachis
No worries @gradyg19, you 're welcome! Have a great day