I have a table, where I need to mark the lines where the column value equals the value in the same column but one row above.
I mean something like this:
I tried the lag node, but it is not exactly I am looking for ( or maybe I coulnd’t use it properly)
I would be grateful for some help
Take a look at the Moving Aggregation node. You may have to apply the rule engine node or column expression node afterwards with an if statement to get the exact format of your “marker” column afterwards.
Thanks, but could you be a bit more specific? I tried this node as well, but couldn’t succeed.
KNIME_project3.knwf (12.9 KB)
In the attached workflow, I used the Unique Count Aggregation in the Moving Aggregation node followed by an if statement in the Column Expression node.
Many thanks for your help.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.