DSXchange

Where exactly are you getting stuck? As Craig suggested, go into the source code of UtilityHashLookup() change the specific code and make your own routine. Here ill help you with that. Now copy paste this code into a new user-defined routine and name it 'myUtilityHashLookup'. Specify three argument...

Where exactly are you getting stuck? As Craig suggested, go into the source code of UtilityHashLookup() change the specific code and make your own routine. Here ill help you with that. Now copy paste this code into a new user-defined routine and name it 'myUtilityHashLookup'. Specify three argument...

DSguru2B wrote:Whats the status on your problem, any progress or stuck somewhere.
Follow Craigs guideline. Its pretty straight forward.

Still unsucessful for getting the HashFile information

rachitha wrote:Hi

Prasad ,,, are you sure that you have data in your hash file..
if not .. first create that hash file and load data into it with the help of any seq file or ODBC stage. then use this hash file in "utilityhashlookup " routine.

Thanks,
Rachitha.

I have the data in the hash file

Or you need to create a copy of the routine that can work with pathed hashed files. Hint - it's a change of one keyword in the routine. :wink: ... i have the hash files in folder "/proj/aspnd/dev/work/HFile/temp11_prasad_test", I tried to replace it in entire line Common /HashLookup/ File...

-Load your second table in a hashed file keyed on 'UNIQUE_KEY'. -Specify the following stage variables FirstNameChk: If ISNULL(in.FIRST_NAME)=1 then UtilityHashLookup(myHashedFileName,1,2) else in.FIRST_NAME GenKey: If ISNULL(in.FIRST_NAME)=1 then GenKey+1 else UtilityHashLookup(myHashedFileName,2,...

Table 1: Source Table FIRSTNAME--LASTNAME--FUNCTION--STARTED_YEAR Sachin--------Tendulkar-----Bat-------1989 --------------Veerendar-----Bat----2001 Rahul------ -Dravid--- ---Bat----- --1996-- ---------- -Raina----- --Bat---------2005 Irfan------- -Pathan------Bowl----- --2004 Munaf-------Patel----...

Table 1: Source Table FIRSTNAME--LASTNAME--FUNCTION--STARTED_YEAR Sachin--------Tendulkar-----Bat-------1989 --------------Veerendar-----Bat----2001 Rahul------ -Dravid--- ---Bat----- --1996-- ---------- -Raina----- --Bat---------2005 Irfan------- -Pathan------Bowl----- --2004 Munaf-------Patel-----...