1.I AM GETTING 3 COLUMNS FROM SOURCE (xx)
P_TYPE
S_TYPE
POLICY_NUMBER.
2.I have 3 cols coming from reference(yy)
p_type
s_type
product_code
3.I need to do this xx.p_type=yy.p_type and xx.s_type=yy.s_type and populate the product_code.
4.If the product_code is null then i need to look up on another (which is my another reference) (zz)
In this there are 3 cols (zz).
accnt_from
accnt_to
product_code
5.if the yy.product_code is null then i need to do the following
if xx.policy_number is between accnt_from and accnt_to then populate product_code.
Can any body tell which stage is best suitable for this logic? and how to implement this logic?
Range Lookup
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 21
- Joined: Mon Jul 12, 2010 2:05 am
- Location: India
As you noted, the first is a simple lookup that you need to ensure continues after a lookup failure. Downstream of that, if the first lookup failed and that value is null, do a second ranged lookup for your 'between' value.
Have you tried to implement it yet? Do you have any specific questions?
Have you tried to implement it yet? Do you have any specific questions?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers