DSXchange

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

what is ur question ,where exactly u r getting problem

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

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).