Delete outstanding values

[pjacob]

Hi I want to keep pattern: A and b (b can be more than one) in my table. I try lag column but nothing comes to mind.
i have:

I want:

[AnotherFraudUser]

Hi pjacob,

sorry I do not understand what you want exactly…
You want to keep all rows where the following row contains a different value?

That you should be able to do with the lag node as well as a rule engine
Example:
KNIME_project3.knwf (6.0 KB)

Maybe this post will help you with the lag-column (if you want to do a negative lag):

Lag Column with Negative value?

Hi there! You are right! Using Moving Aggregation you can simulate negative lag interval in Lag Column node. Window type is Forward, window length-1 determines the lag interval and aggregation is Last on lagging column. Additionally there is another way using just a bit of filtering where number of excluded rows determines the lag interval [NegLagColumn] Workflow is attached so check it out and if any questions feel free to ask. 2019_04_03_ReverseLagColumnOption.knwf (16.2 KB) Rega…

[pigreco]

Can you explain deletion rule.
Do you want clear consecutive A values?
Why did you delete the last A?

[pjacob]

Hello @AnotherFraudUser I also want to keep Row4, Row5, Row6 in your workflow.

[HansS]

Hi @pjacob

With the Lag Column node you are almost there. See this workflow delete_outstanding_values.knwf (14.0 KB) .
gr. Hans

[AnotherFraudUser]

Hi pjacob,

so you only want to filter the equals if the value is “A”?
Then you can use the workflow from HansS

Or change the rule in the rule engine from my workflow to:
NOT $column1$ = $Last(column1)$ OR NOT $column1$ = “A” => “keep”
1=1 => “filter”

*so basically if you want to look ahead you can use my workflow (with the slight change) or if you want to look-behind for your check then use HansS workflow