Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Panel
bgColor#DCDCDC
titleBGColor#808080
titleWhat counts as a duplicate?

There are three cases of duplicate records:

  1. Two or more records have identical values in each and every field (true duplicates).
  2. Two or more records have identical values in some fields, and the fields that do not have matching values are of no consequence (it does not matter which record we take).
  3. Two or more records have identical values in some fields, and one of the variable fields gives us a vale we can select on (in practice, usually a datetime field like 'last updated time').
NameAddressLine1LastUpdatedDateFavouriteDog
Andrew10 Gwydir St.01/02/2017Blue
Andrew10 Gwydir St.01/02/2017Blue
NameAddressLine1LastUpdatedDateFavouriteDog
Andrew10 Gwydir St.01/02/2017Blue
Andrew15 Mill Road03/04/2018Red

Step-by-step guide: Identifying Duplicate Records

...