I have started learning knime recently and now i am at situation where i need to make rule engine with certain filtering criterias. Which were pretty manageable to achieve. But now i want to automate that as well.
Since everyweek when i work on the data set the rules for the same gets updated so instead of doing and checking every rule engine manually I want to pick the rules directly from the excel file to run the filters.
Is there a way to do it?
I found a way to do it with string manipulation but few things were complicated to manage.
There is a Rule Engine (Dictionary) node that was designed for this purpose. You can read in your excel file and pipe the contents into the 2nd port. Be sure to read the node description and note any format requirements.
Thank you for your response. I tried Rule Engine (Dictionary" although it did not work for me because i have two files one with the dataset and another with rules there is a lot of difference. And also i am getting an error of – "Execute failed: Wrong rule in line: Row0
Line: 1: Expected a number, boolean, string or flow variable reference.
yes, i’m uploading the workflow. but before that i have a quick question - Is it possible to apply AND,OR conditions through Rule Engine (Dictionary) like simply we do for Rule Engine.?