look up issue

[adams06]

Hi,


I am doing a lookup, both sorce and lookup(hash file) has matching records. but the records are not hooking up, and no data is coming from lookup.

i deleted the hash file and recreated it.

can some let me what's the prob.

Thanks in advance.

[DSguru2B]

Either the source or the hashed file has spaces in the key. Make sure you trim the keys while building the hashed file and also trim the keys during the lookup coming from the source.

[kris007]

Or there are no matching records

[prabu]

Hi,


I am doing a lookup, both sorce and lookup(hash file) has matching records. but the records are not hooking up, and no data is coming from lookup.

i deleted the hash file and recreated it.

can some let me what's the prob.

Thanks in advance.

i like your terminology

hooking up

.
1)check if your keys are set proper.
2)check for any whitespace characters in your source/lookup files. use trim in the looku"p key.
3)choose some key you know will be "hooked up" and
try view data to match it in source and lookup file, manually.



regards,
Prabu

[meena]

Hi Adam06..
What is your source? What is your lookup? Are you using hash file or DB2 etc for look up.. On which column datatype you are performing look up....

[vsi]

Hi Adam
Make sure the format of the data you are comparing is the same, for ex. date(yyyy-mm-dd) should be compared to same format and as others suggested trim plays important role in look up's,