How to make 3 separate decision table in single excel sheet

533 views
Skip to first unread message

ChennaiCheetah

unread,
May 17, 2021, 12:14:24 AM5/17/21
to Drools Usage
I have 3 separate Guided Decision table in excel  sheet. My Manager wants all rules to be present in single sheet.

By many reason I cannot merge these 3 sheet in single table. There are more than 100 + condition involves among these three.It will be difficult to maintain .

Is there a way to mention different decision table  in different tabs in excel sheet. ?

aas...@gmail.com

unread,
May 17, 2021, 1:34:47 AM5/17/21
to Drools Usage
See https://docs.jboss.org/drools/release/7.53.0.Final/drools-docs/html_single/index.html#decision-tables-defining-proc
how to define multiple decision tables on a single worksheet.

And if you want to have decision tables on multiple worksheets (tabs) then under the same paragraph it is written:

If you want to process multiple worksheet decision tables, then create a .properties file with the same name as the spreadsheet workbook.
The .properties file must contain a property sheet with comma-separated values (CSV) for the names of the worksheets, for example:
sheets=Sheet1,Sheet2

I hope that helps.
Juhan

Nithish Thirmul

unread,
May 17, 2021, 6:06:22 AM5/17/21
to drools...@googlegroups.com
Hi Juhan,

I followed your Steps but still sheet2 is not visible in business central. PFB the steps which got reproduced.

Step1 :  Created two sheets as "Male" & "Female" in excel


image.png image.png

Step 2 : Created properties.file same name as Excel sheet name

image.png



 Post uploading the sheet in workbench,only MALE sheet rule is there. Female rules are missing. Please let me know what  I do wrong





--
You received this message because you are subscribed to a topic in the Google Groups "Drools Usage" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/drools-usage/6E9Q2FRIElc/unsubscribe.
To unsubscribe from this group and all its topics, send an email to drools-usage...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/drools-usage/23e09b35-a7e4-4b9b-98f0-aa63cd41682fn%40googlegroups.com.



CONFIDENTIALITY AND DISCLAIMER NOTE:

These messages including any attachments are intended only for the addressee and may contain confidential, proprietary or legally privileged information. If you are not the named addressee or authorized to receive this mail, you shall not copy, forward, disclose or take any action based on this message or any part thereof. In the event that you are not the named addressee/intended recipient of the e-mail, please notify the sender of receipt of this message and delete this message including any attachment to it from your computer system immediately. The recipient acknowledges that the views, opinions, conclusions and other information expressed in this message are those of the individual sender and shall be understood as neither given nor endorsed by CAPIOT*, unless the sender does so expressly with due authority of CAPIOT and CAPIOT shall not be liable for any errors or omissions in the context of this message. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission.  These messages, unless specifically stated in the email and followed by an agreement, does not tantamount to an offer or an acceptance of an offer by the sender.

* CAPIOT refers to CAPIOT, Inc. and all its subsidiaries including CAPIOT Software Private Limited, CAPIOT Software Pty Ltd, CAPIOT Software Pte Ltd.

Nithish Thirmul

unread,
May 19, 2021, 12:50:10 AM5/19/21
to drools...@googlegroups.com
Hi All,

I have raised a ticket with RedHat (7.10) on the same. They are saying they couldn't confirm more than one sheet is allowed. They need more time on this.

If anyone has a working sample project on this. It would be grateful for us to complete our development activity at the earliest.

Regards,
Nithish
Reply all
Reply to author
Forward
Message has been deleted
Message has been deleted
0 new messages