I think the process works great for duplicates which involves an inactive & active club. We do need to improve the process where exact duplicate values for the same season, club, league and stats.
1) If there is an exact match across multiple lines for the same season as described above -> delete all but one row.
2) For duplicate stat lines across the same season (say club or competition are different) -> validate against synonym file to see if club/comp should be updated and if duplicate perform cleanup as described in 1).
Good example to use is Lee Bonner (Hull Seahawks), see 2013 season (lines 6-7) for an example of 1) and 2014 season (lines 11-12) for an example of 2).
I think the process works great for duplicates which involves an inactive & active club. We do need to improve the process where exact duplicate values for the same season, club, league and stats.
1) If there is an exact match across multiple lines for the same season as described above -> delete all but one row. 2) For duplicate stat lines across the same season (say club or competition are different) -> validate against synonym file to see if club/comp should be updated and if duplicate perform cleanup as described in 1).