Lookup getting zero matches
Moderators: chulett, rschirm, roy
Lookup getting zero matches
I've created a hash file lookup with 2 columns. Key column holds values like: 'Q13A'
My input file has values the same as above. example: 'Q13A'
I've open both files and manually verified there are matches values within both files.
However, when the job runs I get zero matches?! No errors, just nothing joins on the lookup.
Any ideas or help from anyone?
Thanks!
My input file has values the same as above. example: 'Q13A'
I've open both files and manually verified there are matches values within both files.
However, when the job runs I get zero matches?! No errors, just nothing joins on the lookup.
Any ideas or help from anyone?
Thanks!
no constraints...transformer looks like normal lookup..something like this:
[b]Input File[/b]
respid
question [b]Lookup[/b]
bp_file_ques_num--------- bp_file_ques_num
bp_flag
from there first 2 columns of Input are mapped to output and bp_flag from lookup is mapped to output.
Very standard...just no clue why it won't matches values.
[/b]
[b]Input File[/b]
respid
question [b]Lookup[/b]
bp_file_ques_num--------- bp_file_ques_num
bp_flag
from there first 2 columns of Input are mapped to output and bp_flag from lookup is mapped to output.
Very standard...just no clue why it won't matches values.
[/b]
Just check your input columns and output columns in hash file are same..
and makesure you do trim and upcase, no matter they should work...
like you have ino put col as
Fname
lname
mname
seqid
and output as
Fname
mname
lname
seqid
and you are tryinb to make join on lname or mname it would faile
and secondly as said do trim and upcase where ever it is join on charecter fileds
and makesure you do trim and upcase, no matter they should work...
like you have ino put col as
Fname
lname
mname
seqid
and output as
Fname
mname
lname
seqid
and you are tryinb to make join on lname or mname it would faile
and secondly as said do trim and upcase where ever it is join on charecter fileds
RRCHINTALA