I went through the forum to get multirow lookup
I loaded the Flat File to a Hash file
Account is left blank and Directory path also left blank in Hash File stage
File name ContactHsh
In the next job, I used UV stage to get the data from this hashed file
I used localuv as DSN
I cant find the table name
My understanding from the search in this forum is that you dont need SETFILE or VOC pointer if you use local account
Kduke said
i used User_defined queryYou do not need SETFILE if you use the local account. You do this by leaving the Account name blank or the path name blank.
Code: Select all
Select *
FROM "ContactHsh";
What am I doing wrong?
Thanks
Ragu