Skip to Content
0
Former Member
Jun 29, 2016 at 10:15 AM

Iterative Search in BODS

53 Views

Hi,

I have one scenario to implement :

Source Table:

Table A Value1 Value2 1 NULL 2 4 3 5 4 NULL

If Table A Column Value2 is not null for some Value1 (Ex : 2,3)then lookup to Table B:

Table B Value3 Value4 2 5 9 4 5 6 6 NULL 12 22 15 6 3 10 10 18 18 NULL

Here check Value1 = Value 3 (For Table A - Value1 - 2 and 3)

Now if Value4 is not null for Value 3 then search that Value4 in Value3 and repeat this process untill you will not get NULL for Value4.

Ex: Value1=2 in Table A. So in tableB for Value3=2 has 5. Now check 5 in Value3 it has 6. Now Check 6 in Value 3 it has null.

So replace Value1=6.

Final Table:

1 NULL 6 NULL 18 NULL 4 NULL

Thank you very much in advance.

-Amit