Hi,
I am performing a lookup and the result I get is not the desired result.
SrcTable:B,C
LkpTable:A(Key),B,C,D
The lookup is based on the Column B
1.I unchecked the key in Column A of the lkpTable
2.I connected the SrcTable Col B to LkpTable Col B
My Objective is to obtain column D if the SrcTable.Col B
Matches LkpTable.Col B and SrcTable.Col C > LkpTable.Col C
I did a validation for the above rule in the transformer for the respective column but unfortunately it doesnt give me the correct result...
Pls Advice
Problem in lookup
Moderators: chulett, rschirm, roy
Re: Problem in lookup
I resolved the issue by using a custom SQL statement on the lookup Database:
SELECT START_DATE, END_DATE FROM YourHashedFileName WHERE START_DATE <=? AND END_DATE >=?;
(Used the above logic from a contributor )
Thanks a lot guys
SELECT START_DATE, END_DATE FROM YourHashedFileName WHERE START_DATE <=? AND END_DATE >=?;
(Used the above logic from a contributor )
Thanks a lot guys