Knack Data Cleaner

Purpose

Ensures accuracy for HTI compliance and performance dashboards through data validation, deduplication, normalization, and integrity checks. Critical for NCDIT reporting accuracy.

Core Functions

deduplicate_records

Purpose: Identify and remove/merge duplicate device or donor records

Detection Strategies:

• Exact match: Same serial number, donor email, etc.
• Fuzzy match: Similar names, close dates
• Bulk import duplicates: Same acquisition batch