Frequently data can be checked by seeing if it existing in another database. For example, countries, cities, and streets are all well defined, as are car registration plates and popular products. However, when getting people to enter information into online forms or when combining data from two different databases, different practises can frequently lead to different spellings and data which is apparently different even though it should be the same.
At Spotless, we correct these problems by comparing data to a reference dataset. Any data is checked to see if it is present in the reference dataset and if it isn’t then it can be set to the closest match (to correct for typos) or even added to the reference dataset (if it’s missing).
Some of our most popular standard rules use the reference datasets:
You can also create your own reference rules set by uploading your own reference dataset. Remember to share them with the Spotless community!
If you've any questions about Spotless Data or would like to speak with our team, please email firstname.lastname@example.org.