Supporting File Structures|Rule Files

During data analysis, Rule files help determine the data class of the data in each column of the source data.

Rule files specify the tests that the data must pass to achieve the data class associated with the rule file.

Rule files can be active or inactive.

Active rule files are included in the 'Generate Match Criteria' process, inactive files are not.

An example Rule file is shown below.

# FindDuplicateRecords Rule File Version 2.00 
#
# Any value matching ANY of the clauses below is deemed to be in class  
#
# Sample entries
#
# :MANDATORY_SECTION    // The current data value must match all mandatory conditions. 
#                       // There can only be one MANDATORY_SECTION.
#      mandatory_condition1 clause
#      mandatory_condition2 clause
#      ...
#
#
# :OPTIONAL_SECTION :n  // Any n from the total number of optional conditions in the current :OPTIONAL_SECTION
#                       // must match. n is a number 1 -> totalNumberOfOptionalClauses.
#
#      optional_condition1 clause
#      optional_condition2 clause
#      ...
#
#
# :OPTIONAL_SECTION :n  // You can have more than one OPTIONAL_SECTION, but all OPTIONAL_SECTIONs must be 
#                       // satisfied in their own right, for the current data value to be considered in class.
#
#      optional_condition1 clause
#      optional_condition2 clause
#      ...
# 
# // Currently allowable clauses are listed below.
#
# LEGAL_PATTERN[_IGNORE_CASE]="regExp"                  // Data value is in class if it matches the regular expression regExp.
# LEGAL_PATTERN_FILE[_IGNORE_CASE]="fileName"           // Data value is in class if it matches any regular expression 
#                                                       // pattern specified in the list file fileName. (Filename only. The list File must exist in the ListFiles Directory).
# LEGAL_VALUE[_IGNORE_CASE]="dataValue"                 // Data value is in class if it matches the value in dataValue.
# LEGAL_VALUE_FILE[_IGNORE_CASE]="fileName"             // Data value is in class if it matches any value contained in list file fileName. (Filename only. The list File must exist in the ListFiles Directory).
# 


# ---------------------------------
:MANDATORY_SECTION - All must match
# ---------------------------------

LEGAL_VALUE_FILE_IGNORE_CASE="CountryNames.txt"