on 05-28-2015 4:12 AM
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
Para1 | Para2 |
---|---|
01 A | 01 |
02 A | 02 |
03 A | 03 |
04 B | 04 |
05 B | 05 |
06 C | 06 |
07 D | 07 |
Table B
Para2 | Para 3 |
---|---|
01 | 1 |
02 | 11 |
03 | 111 |
04 | 1111 |
05 | 11111 |
06 | 111111 |
07 | 1111111 |
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please consider Table A Para1 values as
A
A
A
B
B
C
C
Apologies for typo.
Thanks in advance
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.