A lookup table contains employee names and IDs. An admin wants to add the employee name to events that contain an employee ID field called 'emp_id'. What is the correct lookup command syntax?
Trap 1: | lookup employee_lookup employee_name FROM emp_id
Incorrect syntax.
Trap 2: | lookup employee_lookup emp_id OUTPUTNEW *
OUTPUTNEW * outputs all fields, but may conflict.
Trap 3: | lookup employee_lookup emp_id OUTPUT employee_name
OUTPUT is fine, but OUTPUTNEW is safer if field may exist. Both are valid, but B is more precise.
- A
| lookup employee_lookup employee_name FROM emp_id
Why wrong: Incorrect syntax.
- B
| lookup employee_lookup emp_id OUTPUTNEW *
Why wrong: OUTPUTNEW * outputs all fields, but may conflict.
- C
| lookup employee_lookup emp_id OUTPUT employee_name
Why wrong: OUTPUT is fine, but OUTPUTNEW is safer if field may exist. Both are valid, but B is more precise.
- D
| lookup employee_lookup emp_id OUTPUTNEW employee_name
OUTPUTNEW prevents overwriting existing employee_name field.