There’s no easy option.

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

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.

Thomas

From: rules-users-bounces@lists.jboss.org [mailto:rules-users-bounces@lists.jboss.org] On Behalf Of Bruno Freudensprung
Sent: 07 September 2011 12:19
To: Rules Users List
Subject: [rules-users] Decision table empty action cell

Hi,

I am implementing a decision table that looks like:

CONDITION	ACTION
$p : Person
name == "$1"	retract($p);
Person name	Retract the person
Fred	N/A
Kenny	N/A

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.

Does anyone know a way to instruct Drools to generate the LHS even if the cell is empty?
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?

Many thanks in advance for your help,
Best regards,

Bruno.