Mapping Specification Guide

Back Next

Lookup Properties

Configure lookup properties when you add or edit a lookup.

Configure the following lookup properties:

Name: Lookup name.
Description: Description of the lookup.
On multiple matches: Determines which rows to return when the lookup finds multiple rows that match the lookup condition. Select one of the following options:
Return first row. Returns the first row that matches the lookup condition.
Return last row. Returns the last row that matches the lookup condition.
Return any row. Returns any row that matches the lookup condition.
Return all rows. Returns all rows that match the lookup condition.
Report error. The Analyst tool reports an error and does not return a row.
Lookup Condition: Configure the following properties in a lookup condition:
Source Column Name. Name of the source column to compare values with a lookup column .
Operator. Comparison operators for the lookup condition.
Lookup Column Name. Name of the lookup column to look up values.
Output: Configure the following output properties:
Lookup Column Name. Name of the lookup column to look up values.
Target Column Name. Name of the target column to output the results of the lookup.