Hey all! I’m learning a lot about knime but there are things yet to learn.
How do I run a rule engine without “filter” the current results, I mean, besides the information I currently have on a column, I need to categorize another one, without “filtering” the previous one.
Hi @Yodata. Do you mean you to apply the Rule Engine to two different columns changing them? The Rule Engine only works on a single column, replacing or creating a new one even though your rule can be as complex as you need. Maybe the Column Expressions node might help, you need to install the Labs extension.
Hi @Yodata , it’s not really clear to me either what you are trying to do.
What kind of filtering are you referring to? Can you show us a sample data and the logic you want to apply along with the expected results on the sample data?
I think that the answer is to use “if statements”, if I am interpreting your post correctly. You can use if statements on nodes that use similar rule engine syntax like “string manipulation” and “math formula” to change column values without filtering them first. I would encourage you to learn the column expression node syntax as well, as it is a far more universally powerful tool.
I was trying to keep the values on a column, avoiding to be erasing by the new rule I was applying, finally I solved by testing the column itself with the expression: