Lookup not found return key ?
Posted: Tue Apr 05, 2005 9:18 am
Hi,
I'm doing a lookup using Lookup Stage (but the same error is appenning with Join stage). Both Input file and Lookup fileset have the KEY field to retreive the VALUE field from Lookup fileset. The output file contains KEY and VALUE fields mapped from the Input and Lookup files.
The problem I'm facing is when the lookup is unsuccessful, the output VALUE field is populated with the KEY field value. I would have expected a NULL... Is that normal or am I missing a detail ?
Thanks !
Isabel
I'm doing a lookup using Lookup Stage (but the same error is appenning with Join stage). Both Input file and Lookup fileset have the KEY field to retreive the VALUE field from Lookup fileset. The output file contains KEY and VALUE fields mapped from the Input and Lookup files.
The problem I'm facing is when the lookup is unsuccessful, the output VALUE field is populated with the KEY field value. I would have expected a NULL... Is that normal or am I missing a detail ?
Thanks !
Isabel