LOOKUP function

[leonracsis]

I have cases where the value to lookup in a reference table does not exist and the map just doesn't process the whole record.
EMP_REC:
EMPLOYEE EMP_CODE
100 A
200 B
300 C

EMP_CODE_REC:
EMP_CODE DEPT
A DEPT 1
B DEPT 2

LOOKUP (EMP_CODE_REC,EMP_CODE_REC:EMP_CODE=EMP_REC:EMP_CODE)

it only returns employees 100 and 200 since they have emp_code values in the lookup. I'd like to include 300 but with a blank DEPT. Similar to an OUTER JOIN if this were an SQL query.

TIA.

 

[BocaBurger]

EMP_CODE DEPT
A DEPT 1
B DEPT 2
C ______ = spaces

Should satisfy your lookup.



BocaBurger
<===========================||////////////////|0
The pen is mightier than the sword, but the sword hurts more!