When you configure a lookup condition, you compare the value of one or more columns in the source data with values in the lookup.
For example, the source data contains an employee_number. The lookup source table contains employee_ID, first_name, and last_name. You configure the following lookup condition:
employee_ID = employee_number
For each employee_number, the Analyst tool returns the employee_ID, last_name, and first_name column from the lookup.
The Analyst tool can return multiple rows from the lookup that match the lookup condition. You configure the following lookup condition:
employee_ID > employee_number
The Analyst tool returns rows for all employee_ID numbers greater than the source employee number.