The use of &quot;Otherwise&quot; is not supported in XLS at the moment.<br><br>There is an open JIRA to address this: <a href="https://issues.jboss.org/browse/GUVNOR-1278">https://issues.jboss.org/browse/GUVNOR-1278</a><br>
<br>With kind regards,<br><br>Mike<br><br><div class="gmail_quote">On 15 August 2012 21:16, dme1 <span dir="ltr">&lt;<a href="mailto:mehtad@hotmail.com" target="_blank">mehtad@hotmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi,<br>
<br>
How do I use &lt;otherwise&gt; in Decision Tables created using Eclipse (Excel<br>
Spreadsheets). I have created a rule where I have provided &quot;&lt;otherwise&gt;&quot; as<br>
a criteria but its been taken as the value of the parameter instead of<br>
creating a separate rule with the &quot;not&quot; clause. I am providing the<br>
screenshot of the decision table as well as the rules generated by Drools.<br>
<br>
I would much appreciate if someone can advise on how I can use &lt;otherwise&gt;<br>
in my rules.<br>
<br>
<a href="http://drools.46999.n3.nabble.com/file/n4019162/droolsdt.jpg" target="_blank">http://drools.46999.n3.nabble.com/file/n4019162/droolsdt.jpg</a><br>
<br>
Drools conversion to &quot;.drl&quot; below (Rule Flight_Type_Rules_15 shows<br>
&lt;otherwise&gt; being used as parameter valUE):<br>
<br>
DRL is :: package com.test.BasicDTRules;<br>
//generated from Decision Table<br>
import java.util.Date;<br>
import com.test.Flight;<br>
// rule values at C11, header at C6<br>
rule &quot;Flight Type Rules_11&quot;<br>
        when<br>
                flight : Flight(flightNumber &gt;= &quot;0001&quot;, flightNumber &lt;= &quot;1000&quot;,<br>
airlineCode == &quot;BA&quot;)<br>
        then<br>
                flight.setFlightType(&quot;SH&quot;);<br>
                flight.setValid(true);<br>
                System.out.println(&quot;Row 1&quot;);<br>
end<br>
<br>
// rule values at C12, header at C6<br>
rule &quot;Flight Type Rules_12&quot;<br>
        when<br>
                flight : Flight(flightNumber &gt;= &quot;0001&quot;, flightNumber &lt;= &quot;1000&quot;,<br>
airlineCode == &quot;AA&quot;)<br>
        then<br>
                flight.setFlightType(&quot;SH&quot;);<br>
                flight.setValid(true);<br>
                System.out.println(&quot;Row 2&quot;);<br>
end<br>
<br>
// rule values at C13, header at C6<br>
rule &quot;Flight Type Rules_13&quot;<br>
        when<br>
                flight : Flight(flightNumber &gt;= &quot;1001&quot;, flightNumber &lt;= &quot;2500&quot;,<br>
airlineCode == &quot;VG&quot;)<br>
        then<br>
                flight.setFlightType(&quot;LH&quot;);<br>
                flight.setValid(true);<br>
                System.out.println(&quot;Row 3&quot;);<br>
end<br>
<br>
// rule values at C14, header at C6<br>
rule &quot;Flight Type Rules_14&quot;<br>
        when<br>
                flight : Flight(flightNumber &gt;= &quot;1001&quot;, flightNumber &lt;= &quot;2500&quot;,<br>
airlineCode == &quot;AA&quot;)<br>
        then<br>
                flight.setFlightType(&quot;550&quot;);<br>
                flight.setValid(true);<br>
                System.out.println(&quot;Row 4&quot;);<br>
end<br>
<br>
// rule values at C15, header at C6<br>
rule &quot;Flight Type Rules_15&quot;<br>
        when<br>
                flight : Flight(flightNumber &gt;= &quot;2501&quot;, flightNumber &lt;= &quot;9999&quot;,<br>
airlineCode == &quot;&lt;otherwise&gt;&quot;)<br>
        then<br>
                flight.setFlightType(&quot;Invalid&quot;);<br>
                flight.setValid(false);<br>
                System.out.println(&quot;Row 5&quot;);<br>
end<br>
<br>
<br>
Thanks,<br>
dme<br>
<br>
<br>
<br>
--<br>
View this message in context: <a href="http://drools.46999.n3.nabble.com/otherwise-in-Excel-Decision-Table-tp4019162.html" target="_blank">http://drools.46999.n3.nabble.com/otherwise-in-Excel-Decision-Table-tp4019162.html</a><br>

Sent from the Drools: User forum mailing list archive at Nabble.com.<br>
_______________________________________________<br>
rules-users mailing list<br>
<a href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
</blockquote></div><br>