Duplicate Jap Serials
After matching a single yr Japanese serial with previous check for duplicates
-- List every value in `jap_2024` that appears more than once,
-- with a count of how many times each one occurs.
SELECT `jap_2024`,
COUNT(*) AS occurrences
FROM `0_jap_raw_serials_mapped_by_year`
GROUP BY `jap_2024`
HAVING COUNT(*) > 1
ORDER BY occurrences DESC, `jap_2024`;
Produces:
The second serial from the top appears to be the correct one, as it has the most comprehensive data when cross-referenced with the raw MDC spreadsheets.
Solution
Make a note of the previous year's serial number. Then delete the row and replace the '-' with that serial number.
Do this in all the captured MDC groups (08, 09 & 10) files of which there a total of 53. The better way is to run a series of customised MySQL queries to do this, which can be constructed quickly in Excel.
Duplicate Jap Serial Fix.xlsx
Topic last reviewed: 22/06/26