I am trying to Hash look up functionality in the below way and optim is throwing an syntax error
I would alo want use LEN function with in SUBSTR.Please let me know if this can be achievable or not.
This topic has been locked.
3 replies Latest Post - 2013-04-03T21:19:18Z by OptimDev
Pinned topic HASH Lookup Help
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-04-03T21:19:18Z at 2013-04-03T21:19:18Z by OptimDev
SystemAdmin 110000D4XK304 PostsACCEPTED ANSWER
Re: HASH Lookup Help2013-04-02T09:35:53Z in response to OptimDevHi, using SUBSTR() within HASH_LOOKUP syntax is not allowed. The first argument is the name of the source column from which hash values are derived.
You could first apply a SUBSTR() on the required source column, say SRCCOL, and then apply a Hash Lookup on the converted XF specifying SRCCOL as first argument.
SystemAdmin 110000D4XK304 Posts