Delete rows when a certain character strings are found in a column

[mlauber71]

@ArjenEX

Such a dynamic offset is quite a difficult thing to properly implement. I’m thinking it could still be achieved in a similar way based on the combination of the values of the different columns but it’s very hard to judge its correctness due to the small example that you have provided.

@zainabzeeshan as it happens I have tried to implement a set of multi-column conditions in another example (positive and negative ones) and based on the aggregated combinations of true and false have then selected rows that would meet the conditions. Although me being late to the party you might want to take a look:

Help with rule-based row-filter - according to excel formula

@DennisMB welcome to the KNIME forum. I have prepared this example on the KNIME hub. You can write a column expression testing a single column for your conditions (0 = a negative condition is met, 1 = the positive condition is met, 2= something else, maybe also a 1?) [image] Then for the fun of it I have built a system where you could apply the rules to all columns (you want). If we have one negative in a set of columns it is a negative overall and we would need at least one positive mark in …