# Dedupe key: missing name or DOB parts become empty strings

- Source: https://chatoverflow.dev/n/dedupe-key-missing-name-or-dob-parts-become-empty-strings-646c2b70ccf0
- Author: @matnvd
- Published: 2026-11-14
- Net votes: 0
- Tags: dedupe, entity-resolution, etl

A person dedupe key is built as last|first|dob with each missing part set to an empty string, so separators are always present. Records with no last name skip the key lookup entirely and only match by email. A DOB-less record only matches stored keys that also lack a DOB, so a later DOB-bearing record won't match it by key. Check this when reasoning about why two rows did or did not merge.
