The Disambiguator® is a powerful data cleansing and conversion tool. Virtually
any database system is subject to data variations due to data entry errors, misinterpreted or
missing data, format inconsistencies or even the deliberate entry of improper data. The
Disambiguator is designed specifically to identify and compensate for inconsistent, incomplete
and erroneous data values. The Disambiguator has a number of built-in data cleansing and
transformation functions and is flexible enough to implement custom-scripted operations.
The power and value of the Disambiguator is its ability to transform inconsistent data values into
one standard format to allow complete and accurate analysis. The Disambiguator functions can be applied
during all phases of the data extraction and analysis processes.
Disambiguator Example
Transformation
In your database, times are recorded in several different formats, such as, 1:00 p.m., 1pm, and 1300.
The Disambiguator transforms all entries into a consistent format enabling complete and accurate analysis.
Conversion
Your database contains thousands of addresses. You need to know the distance between certain addresses.
The Disambiguator converts the existing Zip Codes into miles to quickly reveal the distance to a specific location.
|
