<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor="white" lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">There’s no easy option.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">One solution is to merge the cell across from your condition column – if someone duplicates a row they’ll still have the value merged and it looks nicer than
having a column of N/A<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">The other approach I tend to use is just to set the column heading to be “must be N/A” rather than retract the person.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Thomas<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<div style="border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt">
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext"> rules-users-bounces@lists.jboss.org [mailto:rules-users-bounces@lists.jboss.org]
<b>On Behalf Of </b>Bruno Freudensprung<br>
<b>Sent:</b> 07 September 2011 12:19<br>
<b>To:</b> Rules Users List<br>
<b>Subject:</b> [rules-users] Decision table empty action cell<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt">Hi,<br>
<br>
I am implementing a decision table that looks like:<o:p></o:p></p>
<table class="MsoNormalTable" border="1" cellpadding="0" width="300" style="width:225.0pt">
<tbody>
<tr>
<td valign="top" style="padding:1.5pt 1.5pt 1.5pt 1.5pt">
<p class="MsoNormal"><b>CONDITION</b><o:p></o:p></p>
</td>
<td valign="top" style="padding:1.5pt 1.5pt 1.5pt 1.5pt">
<p class="MsoNormal"><b>ACTION</b><o:p></o:p></p>
</td>
</tr>
<tr>
<td valign="top" style="padding:1.5pt 1.5pt 1.5pt 1.5pt">
<p class="MsoNormal"><b>$p : Person</b><o:p></o:p></p>
</td>
<td valign="top" style="padding:1.5pt 1.5pt 1.5pt 1.5pt"></td>
</tr>
<tr>
<td valign="top" style="padding:1.5pt 1.5pt 1.5pt 1.5pt">
<p class="MsoNormal"><b>name == "$1"</b><o:p></o:p></p>
</td>
<td valign="top" style="padding:1.5pt 1.5pt 1.5pt 1.5pt">
<p class="MsoNormal"><b>retract($p);</b><o:p></o:p></p>
</td>
</tr>
<tr>
<td valign="top" style="padding:1.5pt 1.5pt 1.5pt 1.5pt">
<p class="MsoNormal"><b>Person name</b><o:p></o:p></p>
</td>
<td valign="top" style="padding:1.5pt 1.5pt 1.5pt 1.5pt">
<p class="MsoNormal"><b>Retract the person</b><o:p></o:p></p>
</td>
</tr>
<tr>
<td valign="top" style="padding:1.5pt 1.5pt 1.5pt 1.5pt">
<p class="MsoNormal">Fred<o:p></o:p></p>
</td>
<td valign="top" style="padding:1.5pt 1.5pt 1.5pt 1.5pt">
<p class="MsoNormal">N/A<o:p></o:p></p>
</td>
</tr>
<tr>
<td valign="top" style="padding:1.5pt 1.5pt 1.5pt 1.5pt">
<p class="MsoNormal">Kenny<o:p></o:p></p>
</td>
<td valign="top" style="padding:1.5pt 1.5pt 1.5pt 1.5pt">
<p class="MsoNormal">N/A<o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><br>
The problem is generated rules have an empty RHS unless I put a string (here N/A) on each line of the Action column, and I'd like to hide this column in my final spreadsheet.<br>
<br>
Does anyone know a way to instruct Drools to generate the LHS even if the cell is empty?<br>
If it is not possible, do you know any Excel trick to automatically fill the Action cell with an arbitrary value (here N/A) when a new line is inserted in my table?<br>
<br>
Many thanks in advance for your help,<br>
Best regards,<br>
<br>
Bruno.<o:p></o:p></p>
</div>
</div>
<br>
<hr>
<font face="Arial" color="Gray" size="1"><br>
**************************************************************************************<br>
This message is confidential and intended only for the addressee. If you have received this message in error, please immediately notify the postmaster@nds.com and delete it from your system as well as any copies. The content of e-mails as well as traffic data
may be monitored by NDS for employment and security purposes. To protect the environment please do not print this e-mail unless necessary.<br>
<br>
NDS Limited. Registered Office: One London Road, Staines, Middlesex, TW18 4EX, United Kingdom. A company registered in England and Wales. Registered no. 3080780. VAT no. GB 603 8808 40-00<br>
**************************************************************************************<br>
</font>
</body>
</html>