LooKUp Stage Condition

srini.dw · Post by **srini.dw** » Wed Oct 04, 2006 8:09 am

Hi,
In PX7.5 Lookup Stage having constraints Condition Not Met,Lookup Failure.
My Source columns as ecode,scode,date...
Lookup columns as ecode,scode,datein,dateout...
Baded on ecode,scode i am specifying lookup condition,After that as for my requirement specifying condition as (date>=datein and date<dateout).This condition will work on lookup stage condition not met.

Thanks

samsuf2002 · Post by **samsuf2002** » Wed Oct 04, 2006 10:59 am

what is ur question ,where exactly u r getting problem

us1aslam1us · Post by **us1aslam1us** » Wed Oct 04, 2006 11:10 am

Hi srini,

I guess the simple way will be to use transformer stage after the lookup stage(lookup on ecode and scode) for checking the date condition. And if you want to capture the rejects , get the lookup rejects and append them with the "condition fail" rejects in the same file.IHTH.

Sam

ray.wurlod · Post by **ray.wurlod** » Wed Oct 04, 2006 3:09 pm

What do you seek to achieve? The "condition" determines whether to attempt the lookup at all, not the condition clause in the lookup processing. A Lookup stage can only do an "=" match on the key column(s).