Hi,
I need a solution for one of my requirement, which is as follows:
1. I have a Look up table In which I have column named as "Profit Center".
2. I have a reference table in which I have two columns "Valfrom" and "Valto"
3. I need to specify a condition in Lookup stage as
"profit Center">="valfrom" and "profit Center"<="valto".
Please suggest me how do I do this?
Regards
Prasanna lakshmi
Condition in Lookup stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you are using DB2 or Oracle Enterprise stage to feed to reference input link then you could use this SQL.
Otherwise use a Join stage, or upgrade to version 8 in which the ability to perform range lookups is in the Lookup stage. Vincent has created a recent blog on the latter.
Otherwise use a Join stage, or upgrade to version 8 in which the ability to perform range lookups is in the Lookup stage. Vincent has created a recent blog on the latter.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: