Lookup Field Selection

There are three options for field mappings as listed below.

• Key field: A key field is a usually a unique field used to match the data entered in the Index field. However, the program supports an unlimited number of key fields. In this case, all key fields must match, even if blank, in order to return values to the corresponding return value index fields. Key fields are the fields used to match or filter records from the lookup table when running a Query lookup.

• Return value: Return fields contain the information that populates the mapped field name with its corresponding data.

• Key field and return value: The return value of a first lookup is used as key value to perform a second lookup.

Truncate whitespace: Selecting this option causes all spaces at the end of the values contained in the return fields to be removed once the value is placed in an index field.

Do not populate if field is already populated: When this feature is enabled, PSIcapture does not populate an index field already populated with data after performing a lookup.

• Entire Value: The entire return value is populated in the field.

• Subset: Only a portion of the return value is populated in the field, denoted by a starting position and an ending position.

• Split: Only a portion of the return value is populated in the field, denoted by a split character and element number.