Worksheet

Duplicate diagnosis sheet

Four rows, one per cause, fill this sheet. Columns give the symptom to look for in the data, the query or export that finds it, the likely fix and the owner. A lower block lists the merge steps for a duplicate group: survivor, records retired, history moved and date merged.

Name: ______________________   Business: ______________________   Date: ______________

Scroll the table sideways to see every column.

Cross out or rewrite any heading that does not fit your business. From the guide “Why records duplicate after two systems are connected”, www.gullysystem.com/blog/why-records-duplicate-after-two-systems-are-connected