When one column doesn't identify a row, combine columns. Deduplicating on only part of a composite key removes valid rows.
- Lesson: Find the row grain before removing duplicates
- Practise: Deduplicate order lines at the right grain
Related: Row grain, Deduplication