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
LooKUp Stage Condition
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.