Field Mapping

Defines a mapping between a value or column from a Lexicon and a Grooper Data Field for lookup population.

Remarks

The Field Mapping object specifies how data retrieved from a Lexicon during a Lexicon Lookup operation is assigned to a target Data Field. Each mapping links a field in your data model to a value or column from the Lexicon entry, enabling automatic population of multiple fields from a single lookup result.

Purpose and Usage

• Use Field Mapping to populate one or more Data Fields with values from a Lexicon when a lookup is successful.
• Supports both single-value and multi-column Lexicon entries.
• For multi-column data, the 'Column Number' property determines which value is assigned to the target field.

Configuration Guidance

• Add a Field Mapping for each field you wish to populate from the lookup result.
• For single-value Lexicons, set 'Column Number' to 0 to use the entire value.
• For multi-column Lexicons, set 'Column Number' to the 1-based index of the desired column.
• Do not map the same field as both the lookup key and a target.

Best Practices

• Ensure that each mapping references a valid target field and the correct column number.
• Review your Lexicon structure to confirm the order and meaning of columns.
• Test lookups with sample data to verify correct field population.

Example Scenario

For a ZIP code lookup with entries like 76049=Granbury,TX,Hood:

• Map column 1 to a 'City' field, column 2 to 'State', and column 3 to 'County'.

For more information, see the documentation for Lexicon Lookup, Lexicon, and Data Field.

Properties

Name	Type		Description
Target Field	Data Field	►	The Data Field to populate with the lookup result. ConverterTarget Field Converter Requiredtrue The 'Target Field' property specifies which Data Field will receive the value from the Lexicon entry when a lookup is successful. This field should be present in the current data model and should not be the same as the lookup key field. Select the field you want to populate with the lookup result. For multi-field population, add additional Field Mapping objects as needed. Example: Map the 'City' field to column 1 of the Lexicon entry for a ZIP code lookup.
Column Number	Int32	►	The 1-based column number to read from the Lexicon entry. Default0 The 'Column Number' property determines which value from a multi-column Lexicon entry is assigned to the target field. Set to 0 to use the entire value (for single-value Lexicons or when only one value is present). Set to 1 or higher to select a specific column from a delimited entry. Example: For an entry like 73536=Duncan,OK,Stephens: Column 1: "Duncan" (City) Column 2: "OK" (State) Column 3: "Stephens" (County) Set 'Column Number' to 2 to populate the 'State' field with "OK". Ensure the column number does not exceed the number of values in the Lexicon entry. The delimiter is specified by the 'Column Delimiter' property on the Lexicon Lookup.

See Also

Data Field

Used By

Lexicon Lookup