I’m currently facing an issue that for me looks very hard with no resolution. the attached image is for a daily report that I extract and the outcome is originally color coded, but in KNIME, I don’t see color coding nodes. so I want to convert the content of cells to text format.
if the cell has a date, it means that this is the date on which the task was “Completed”
if the cell has a positive number, then this means that task is “In Progress”
if the cell has a negative number, then this means that Task is “Late”
if the cell has no value and empty, then this means that task is “Not Opened”
I have attached a screen shot from the last table in outcome from the the model and wish someone can help me out!!
Here I have some problems.
Rule engine node does not accept flow variable for MISSING so we have to make a workaround by filtering missing values (this is solved).
The second problem is that with column name as flow variable the rule engine node in the loop does not give the same result as the rule engine outside the loop (without flow variables).
I can not figure out where is the problem. Maybe someone else can help.
I still do not know what is wrong with Rule engine in the loop with flow variable, but I have made another solution for this particular case which you can try.and upgrade if necessary Column loop II.knwf (51.0 KB)