cancel
Showing results for 
Search instead for 
Did you mean: 

Can Decision Table skip the rows/columns

Former Member
0 Kudos

Hi,

I have a requirement this way,

Fora Table A, Para 1 values 04 and 05 come under same  para 2 value as B. Now my logic does it the following way

for Table A, Para1 = B,the value this decision table will fetch is 04,then it will go to Table B and will fetch 1111 against value 04. Will take this 1111 value and will check in database table if there is any entry for 1111. If it does not get any value should return to BRFplus table A with value B. But here it will again pick 04 and not 05 against value B. How can we skip 04 this time around and pick 05 against B? Can you please advise on skipping the levels in this decision table? Thanks in advance

Table A

Para1Para2
01 A01
02 A02
03 A03
04 B04
05 B05
06 C06
07 D07

Table B

Para2Para 3
011
0211
03111
041111
0511111
06111111
071111111

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

Hi,

you cannot skip rows in a decision table. The table is always evaluated from top to bottom.

In your case you can use multiploe match mode in the settings of your decision table (return all matches found) so you get all results coupled to the param B in your example. Then loop over the result and do your DB lookup in the loop. After the DB lookup implement the ruole that leaves the loop with the result if an entry was found. In the other case make the next iteration in the loop which is the next entry in your result table.

Cheers

Christian

Former Member
0 Kudos

Please consider Table A Para1 values as

A

A

A

B

B

C

C

Apologies for typo.

Thanks in advance