Good Day , dear KNIME users :blush: I am struggling with combination of rule engine and math formula. In this case I have to check date with the next row, if they are equal I have to take difference between lets say row3 Column D - row 2 Column E (with previous row) [image] I have kinda done it using rule engine and lag, but seems like it is not proper solution. I can use snippers, but unfortunately I do not know programming language yet :frowning_face: [image] date.knwf (80.1 KB) I have attached my current workflow Looking for you help and great ideas :smiling_face_with_three_hearts:

hi @aworker and @Karlygash yes the workflow contains three copies of a component but clicking Yes to update (or No :wink: ) should allow it to work. However, what I’ve done now is “disconnected” the component from its reference on the hub so hopefully it won’t ask for updates any more. Apologies for delay, but I had to catch up on the previous messages as I hadn’t been following the “moving aggregation” part of the flow, as I knew that bit was already in (more) capable hands. :thinking: :smile: However, I think I understad, that basically each time the employee name changes, we need to have the “last” values from the moving aggregation set to missing just as it is for the final row in the dataset. Assuming I got that bit right, then that “First and Last for Group” component can come to the “rescue”. If we ask it to mark the first and last row for “Employee Name” [image] then what it does is populate two columns “EmployeeStart” and “EmployeeEnd”. [image] This then makes it super easy to use a Rule Engine to “fix” the “last” values at the end of each Employee window [image] [image] [image] [image] Is that what is needed? I know it’s a bit of a “cheat” but this is exactly the kind of situation that component was written for :wink: (And apologies if I’ve misunderstood what was being asked!) emp_data_2.knwf (619.3 KB) [Edit: re-uploaded without resetting data :wink: ]

Combination of math formula and rule engine

KNIME Analytics Platform

ipazin June 23, 2021, 11:23am 2

Hello @Karlygash,

Lag node followed by Rule Engine seems like a way to go in this case. One things that could help you is a negative lag to get next date(s) one row up. See here:

Br,
Ivan

2 Likes