Hello Team - just want to seek help how can I automate my process wherein we have a lot of rules to consider just to get its correct STATUS and PERCENTAGE.
In the attached excel file, we have a pre-defined rules under Remarks column and our identifier is in under Analysis 1, Analysis 2 and Analysis 3 columns.
What will be the best way to approach it? Hope you guys can help me as this is very and super tedious to do it manually imagine we have thousands lines evaluating each of it and it is very repetitive. Those rules are the ones we usually consider under remarks column.
I don’t think there’s a way to use manual rules in any of the standard Knime classification nodes. You’ll need to try the Rule Engine, Column Expressions or Expression nodes. You’ll need to translate your “rules” in the remarks column into the appropriate Knime parlance rules for the node you want to use. BTW - your data is a mess because of the format of your Excel data file.
Your choice. The Column Expressions node easily handles If…else if… else rules. Everyone seems to be moving to the Expressions node. I haven’t got my mind around it yet.
