Skip to Content

Pass Decision Table Cell Value to Expression


We have a decision table where there are two condition columns, let's say, sales organization and sales office. Now, we want the combination of these two columns to be matched against a table of sales areas (sales organization and sales office) and then depending on whether there was a match or not, we want to return the appropriate output from the decision table. Currently, we have achieved this using a loop on the table of sales areas and looking up the decision table to get the first match. This works fine functionally but we are exploring if there is a better way to achieve the same thing, maybe, something like embedding an appropriate expression in the decision table, either in the columns or in the cell values. Yes, we know it's possible to add an expression (like a function call) as a condition column in a decision table, but in that case, we don't have an option to pass "cell" values to that expression for matching purposes. Also, it important to note that we are looking at combination of cell values to be matched rather than a single value.

Any useful inputs would be appreciated.



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Nov 18, 2015 at 11:22 AM

    Hi Akshat,

    if I got your requirement correctly, I would solve your requirement the following way:

    I assume that the sales area table is stored in the backend and you can use a DB lookup expression to get the result. If I understand correctly it is an existence check so you can use that flavor of the expression.

    In addition, I would define a local variable in the rule set like IS_PART_OF_SALES_AREA type boolean and use this variable as a decision table column to define your conditions. In the decision table you can then use the DB lookup expression (with your sales office and sales organization as input) in order to determine the value i. e. if the data set under investigation is part of the sales area.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.