User Guide > Setting Preferences > Setting Data Profile Preferences > Setting Data Profile Rule Defaults
Was this helpful?
Setting Data Profile Rule Defaults
To set the Data Profile rule defaults:
1. Go to Options > Preferences.
The Preferences dialog is displayed.
2. In the left-pane, expand DataConnect and then expand Data Profiler.
3. Click Rule Defaults.
4. Set the defaults.
You can restore the defaults by clicking Restore Defaults.
Rule Parameter
Values
Compare to Constant, Operator
Select one of the following options:
Equal (default)
Greater
Greater or Equal
Lesser
Lesser or Equal
Not Equal
ComparetoField, Operator
Select one of the following options:
Equal (default)
Greater
Greater or Equal
Lesser
Lesser or Equal
Not Equal
Distinct Values, Sort Order
Select one of the following options:
Field Data (Faster)
Frequency Count (Slower)
Note:  Frequency Count (Slower) sorts the results in descending order and hence the sorting is slower compared to Field Data sort option.
Duplicate Values, Sort Order
Select one of the following options:
Field Data (Faster)
Frequency Count (Slower)
Note:  Frequency Count (Slower) sorts the results in descending order and hence the sorting is slower compared to Field Data sort option.
Duplicate Values, Min Count
Click on the text box to specify the required value.
Default value is 2
Equal Range Binning, Range Count
Click on the text box to specify the required range count.
Default value is 10
Matches Regex, Regex Pattern
Click on the text box to specify the required regex pattern.
Default value is .*
Specifying “.*” matches against any sequence of characters.
Preferred Date Pattern
Click on the text box to specify the preferred date pattern.
Default value is yyyy-MM-dd
Preferred Timestamp Pattern
Click on the text box to specify the preferred timestanp pattern.
Default value is yyyy-MM-dd HH:mm:ss
Preferred Time Pattern
Click on the text box to specify the preferred time pattern.
Default value is HH:mm:ss
Most Frequent Values, Top How Many
Click on the text box to specify the required most frequent values.
Default value is 25
5. Click Apply and Close o save the changes.
Last modified date: 10/22/2024