How do I match potential duplicate observations using the exact source, subject and day?
Case and leading or trailing spaces are ignored for source and subject. Matches are candidates for manual review.
Open Duplicate FingerprintTry the worked example
These are the example inputs from Duplicate Fingerprint. Replace them in the tool to run your own case.
| Record ID | Source | Subject code | Observed day |
|---|---|---|---|
| R1 | Interview | A-08 | 2026-10-21 |
| R2 | interview | A-08 | 2026-10-21 |
| R3 | Survey | A-08 | 2026-10-21 |
Example result
1 repeated observation
Who uses this?
Research operations lead. The free online tool runs the calculation in your browser. To edit the files and use the tools offline in one business, see the €49 offline edition.
Where the idea came from
Match potential duplicate observations using the exact source, subject and day. The creator advocates putting a prototype in front of people and collecting evidence about real use. Benchcraft designed this tool’s inputs, decision rule and example for this office task.
Original video