Forum Discussion
Nested duplicated MLB Players list
Hi,
I’m having a crazy “Duplicated” challenge but I’m out of options, I have a list of MLB players stats since early 90's, for each year I have the same player, till they are actif of course, I would like to create a list of unique MLB players to use as dimension table.
I've extracted list of names, handedness and positions attributes: 2 issues where the first can’t be solved because of the second.
- Players could play multiple positions, ex. Adam Dunn played OutField [OF], InField [IF] and Designated Hitter [DH]
I could removed duplicated based on [FullName] + [Handedness] but… - Also multiple players could share the same name, ex. Adam Eaton Pitcher and Adam Eaton OF
but also players could share the same name and handedness, ex. Will Smith Pitcher and Will Smith Catcher
Yeah I know… Other options are welcome!
Thx,
2 Replies
For Item 2, you need an additional piece of info to make each player unique e.g. birthdate, middle name, height or something. Hopefully you can add it to your data early on in the process and without doing it manually but if that's the way it has to be done, then that's what you have to do.
Item 1 isn't really a problem - it just depends on what you are using the data for. It works as a Fact table, if you want to keep track of the different positions players have. If you want to use it as a dimension table, then use a primary position field or get rid of the positions and remove duplicates.
Hi HotChilli,
Thx, I like the "Primary position" suggestion. Add an additional piece of info for player isn't an option.
Grtz,
