Profiling field values by meta type
Profiling by meta type affects how data is sorted when you profile a field in a process configuration dialog. You can sort field values for data types such as dates, money, and other numeric data.
1.
Open any process configuration dialog in which the Profile option is available.
2.
Select a field for profiling or click
Profile
.
3.
Profile Selected Field
The
Profile By Meta Type
option is enabled by default, so field values that represent dates, money, telephone numbers, and similar data types are correctly sorted and binned.
For example, dates are sorted as dates, not as numeric values. If you disable this option, the values are sorted as ASCII text.
The following example shows how this setting affects a date field. Meta type profiling recognizes that the data type is Date and sorts the dates accordingly.
Profile by Meta Type enabled
(sorted by date)
Profile by Meta Type disabled
(sorted numerically)
25-DEC-2011
20-FEB-2012
20-FEB-2012
20-MAR-2012
20-MAR-2012
25-DEC-2011
Copyright IBM Corporation 2015. All Rights Reserved.