dtables | Simple descriptive frequencies and statistics in R | Data Visualization library

I'm messing around with Drools decision tables in eclipse and noticed that the only way I've been able to import a rules file into my Kie session involves placing the file directly in the eclipse project. I was wondering if there was a way to access a rules file located somewhere in "C:Users/user/documents/rules/" or if the file had to be in the workspace.

I'm not super familiar with Drools or KIE so the only knowledge of the services that I have involve the documentation on the website and the various tutorials across google and youtube. The code that I've found so far doesn't seem to be enough.

I have below code which is calling drools rule engine from spark.

Spark Version : 2.3.0

I am looking through Drools as a possibility for a rules application use case. I am able to get Drools to reference the rule-set from a .xls file and a .drl file independently of each other at this point in time. However, in my case there are times where the rules do not exist as a .xls file and will be programmed within a .drl file. Because of this, I am wondering if within the same program execution, both files could be used depending on certain input criteria? For example, if State == "GA" then use .xls, else if State == "FL" then use .drl.

I have read on the different KieConcepts and understand them at a high-level, and I believe that I would have to create each rule file as a separate KieContainer and then load them into a single KieBase based on the definitions given to each here. However when it comes to this step I get confused as to how this is accomplished. I have two separate instances already created, would I be able to simply combine these two in one program using a KieBase?

The .xls Implementation

I'm new to Drools and decision tables. I need to create a rule to test if a Person is Older/young using the person age for the rule. The rule works but in infinite loop.

This is the rule, is basic, person age > 18 then the person is older, or, person age less than 18, person is young. The following is the HTML from my Excel file:

I have a drools decision table in excel spreadsheet with two rules. (This example has been greatly simplified, the one I am working with has alot more rules.)

The first rule checks if amount is more than or equal to 500. If it is, then it sets status to 400. The second rule checks if status is 400. If it is, then it sets the message variable. The problem is, I am unable to get the second rule to fire, even though sequential is set. I also have to use no-loop and lock-on-active to prevent infinite looping.

My goal is to get the rules to fire top down, and the rules that come after might depend on changes made to the fact/object by earlier rules.

Is there a solution to this problem? Any help would be appreciated, thanks!