Rule engine

Hello everyone, I would like to solve the following problem with the Rule Engine node: My goal is to calculate the days elapsed since the last change of condition from “TRUE” to “FALSE” and from “FALSE” to “TRUE”, considering the columns: Date and Condition. Thank you to whoever will help me. Here is the Excel file.

Example_.xlsx (9.9 KB)


here is a possible solution using column expression’s long memory feature (have a look at this: Column Expressions have Long Memories too! - Resources / Knowledge sharing - KNIME Community Forum)

Here’s the wf:

Have a nice day,
Raffaello Barri