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!!
The rule engine isn’t the best solution as this needs to be an overall application over the whole report, but rule engine is taking it column by column.
The rule somehow worked, but the part with the completed rule wasn’t captured in the below screen shot, and it was stated as in progress
Any ideas how to over come this issue?
Now, how can I make the Loop to run this same thing over all the columns? because I tried the node “Column list loop start” but I’m not familiar with how to use and what are the steps to follow.
Hi @HansS - Can you be able to help me how to make the loop have the rule engine node runs across all columns at once instead of going column by column?
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)