Range Lookup

[jpradeep.net]

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?

[chulett]

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?