You are not logged in.
Hi there, first post from newbie.
2 input tables :
1 output table : gests two lines
input1.id is mapped with outpu3.id
input1.date is mapped with outpout3.date
input2.desc is mapped with output3.desc
input1.id is linked to intput2.id as well as input1.date to input2.date (unique match)
'til then, fine. BUT.
Here is my question : I would like system to lookfor (lookup) the input2 date as inferior or equal. If no row exists in input2 for input1.date, select date from input2 where input2 <= input1.date to find previous record
Thanks in advance
Last edited by brunodenis (2008-01-30 11:22:52)
I think this job could help you to resolve your problem.
Do not matter to errors in tMap_2, they does not appear in final code generation.
With this job I test it with these inputs:
And final output is:
Last edited by amaumont (2008-01-30 15:42:01)
Ok, solve the problem thanks to the given tip .
Nevertheless, it has not been necessary to build such complex job. In first tMap, lookup rejects the rows where dates not found (unique match) in a file that is the exact copy of the source.
Then, in the second tMap, I have treated rejections with your tip (filter on the lookup source.date.before(lokkup.date), last match).
So it didn't need the tJavaflex and so on...
Many many thanks anyway.
Last edited by brunodenis (2008-01-31 10:36:11)