LookupOption

General options for the lookup operation.

Remarks

Overview

The LookupOption enum defines flags that modify how Value Lookup processes and outputs values. These options allow you to control whether values must match the vocabulary, how punctuation and case are handled, and whether translation or normalization is performed.

Usage

Combine options as needed to achieve strict validation, flexible normalization, or custom output formatting. These flags are typically set via the 'Lookup Options' property on a Value Lookup object.

Available Options

• None: No special options are enabled; only exact matches in the vocabulary are accepted.
• AllowMiss: Values not found in the vocabulary are still included in the output, allowing for fuzzy repair or translation without strict filtering.
• CleanKey: All punctuation and control characters are removed from values before lookup, enabling matches that ignore formatting differences.
• UseListCase: Output values reflect the case of the vocabulary entry instead of the document value, ensuring standardized casing.
• Translate: Output values are replaced with mapped values from the vocabulary when configured as a 'Lookup' lexicon (key-value pairs).

Best Practices

• Use 'None' for strict validation.
• Enable 'AllowMiss' for normalization or correction scenarios.
• Use 'CleanKey' to handle values with inconsistent punctuation.
• Enable 'Translate' to map synonyms, abbreviations, or codes to standardized forms.
• Combine options as needed for your use case.

A combination of the following flags:

Used By

Group OptionsValue Lookup