Each attribute and row of an entity contains a set of distinct values. One of the first steps in understanding your data is examining distinct values in attributes and their corresponding rows.
This will tell you:
- How often a value is repeated within an attribute
- Which rows contain the value
- Which attributes contain more distinct values than others
You can then:
- Look at the minimum and maximum range of values in any attribute and drill down to see which rows contain those values
- Recode data values
- Generate and export recode value look-up tables to be used in the Quality Transformer process
- Learn more about the values that make up your data by performing phrase analysis and investigating soundexes and metaphones.