Glossary

Leading zeros

Zeros at the start of an identifier like 005642. They are part of the identifier.

Codes, account numbers and postal codes are text, even when they look numeric. Converting them to numbers drops leading zeros and can merge different identifiers.

Lesson: Trim the right characters, and only those
Practise: Pick one surviving record per account

Related: Identifier, Trim