Skip to Content

Decision Table lookup with wild characters

Hello Experts,

I have a decision table with 3 columns, the first 2 are condition columns and the 3rd one is a result column.

I have values maintained in the following manner

A1 111 Pack A1 211 Freeze A1 311 Reject B1 911 Send

Now I want search my table as A1 and * and I expect all 3 values of 'Pack' , 'Freeze' & 'Reject' as my result.

How do i do that?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 15, 2015 at 06:18 PM


    your requirement does not really match the idea behind a decision table: the decision table is intended to return a result if all conditions specified in the condition columns are met. ALthough tehre is the concept of a partial match mode this mode does not return the partial matches but an exception that contains the maximal number of matched condition columns (in your case 1)

    In order to retrieve the result you want you have to design the table differently:

    A1111PackA1211FreezeA1311RejectB1911SendA1PackA1FreezeA1Send But from my point of view that is not logical at least I cannot imagine a scenario where this would fit as you specified the second condition not without any intention. WIth the above design you can also omit the first three rows. You can also use e. g. boolean expressions in the second column in order to model such a behavior, but as already mentioned it is hard to think of a scenario where that is logical. Perhaps you should also take a look at the search tree expression and its capabilities, perhaps that is more fitting for your scenario Best RegardsChristian
    Add comment
    10|10000 characters needed characters exceeded