I’m using KNIME to automate some processes and I’m attempting to clear my table of some premises that shouldn’t be there. However, the rule-based row filter ignores the code and just sends out the exact same table as before. What I was coding looks like this:
The idea is that the rows that have parameters 1, 2 or 3 are excluded from the end table. The node executes as normal and does not send any errors to the console, but when I preview the table, the rows with parameters 1, 2 and 3 are still in. This is especially upsetting me because I’ve done similar rule-based row filters in the past (with the exact same syntax with the exact same purpose) and it worked as expected before.
You can filter on added column. Just to make sure that your data is correct. Also, restart KNIME if you did not do this yet. Check for extra spaces, invisible symbols and such.
Because this was a bit of a time sensitive issue, and I could not figure out what was wrong with the code, I gave up using the node and figured a way around it (I executed the step in a different part of the flow, utilizing other nodes that have not given me trouble so far). I might try to offer an example later if I can, but I believe it might be a glitch that I got lucky enough to find (multiple times, in different flows, even. Lucky me!), especially because sometimes it works gracefully and sometimes it gives me trouble like this.
Thanks everyone for the offered support and suggestions!
glad you found a workaround and if you manage to create an example workflow I will definitely take a look at it and check is it a bug or miss configuration
Hi GiPiconi,
I had similar problem with filtering using Rule-base Row Filter node.
This node better works with positive indication, so your code shud look sth like that:
$column1$ IN (“parameter 1”, “parameter 2”, “parameter 3”) => TRUE
Exlude TRUE matches.
Hope this help.
