We recently stumbled across this unintended data quality error as a result of what should have been a simple data processing task.
The task was to remove “The” from a string as the target field was too small to receive the data. They unwittingly removed “The” from anywhere in the string, so, rather than just at the start and removing “The” for example “The Weather Channel”, they removed it from anywhere in the name and the following ensued..
|Physical Therapist||Physical rapist|
|Speech Therapist||Speech rapist|
|Child Therapist||Child rapist|
|Group Therapist||Group rapist|
|Psycho Therapist||Psycho rapist|
|Occupational Therapist||Occupational rapist|
|Play Therapist||Play rapist|
|Family Therapist||Family rapist|
|Massage Therapist||Massage rapist|
|Trauma Therapist||Trauma rapist|
To avoid this kind of mistake demands experience and an appreciation of what can happen when data is not treated with respect. At DQ Global® we have over 10 years’ experience dealing with Data Quality issues in a vast array of industries. Our Data Quality Software and our years of knowledge can help you overcome all sorts of Data Challenges. Look around our website to see how our Data Cleansing and Deduplication Software will help you avoid any embarrassing Data Blunders!