This node takes a list of user-defined rules and tries to match them to the defined flow variables. If a rule matches, its outcome value will become the value of the flow variable. The first matching rule will determine the outcome.
Each rule is represented by a row. To add comments, start a line in a (condition) cell with // (comments can not be placed in the same line as a rule). Anything after // will not be interpreted as a rule. Rules consist of a condition part (antecedent), which must evaluate to true or false , and an outcome (consequent, after the => symbol) which is put into the new flow variable if the rule matches.
\n \nThe outcome of a rule can either be a constant string, a constant number or boolean constant, or a reference to a flow variable value. The type of the outcome column is the common super type of all possible outcomes (including the rules that can never match). If no rule matches, the outcome is "", 0, or 0.0 depending on the output type.
\n \nNumbers are given in the usual decimal representation. Note that strings must not contain (double-)quotes (for those cases use the following syntax: /Oscar Wilde's wisdom: "Experience is simply the name we give our mistakes."/ ). The flow variables are represented by $${ TypeCharacterAndFlowVarName }$$ . The TypeCharacter should be 'D' for double (real) values, 'I' for integer values and 'S' for strings.
\n \nThe logical expressions can be grouped with parentheses. The precedence rules for them are the following: NOT binds most, AND , XOR and finally OR the least. Comparison operators always take precedence over logical connectives. All operators (and their names) are case-sensitive.
\n \nSome example rules (each should be in one row):
\n \n// This is a comment\n$${DFlowVar0}$$ > 0 => "Positive"\n\n FlowVar0 has value above zero, in which case the result flow variable has the value Positive.\n \n $${SFlowVar0}$$ = "Active" AND\n $${IFlowVar1}$$ <= 5 => "Outlier"\n\n When FlowVar0 is "Active" and FlowVar1 is greater or equal to 5, then the result is Outlier.\n \n $${SFlowVar0}$$ LIKE "Market Street*" AND\n ($${SFlowVar1}$$ IN ("married", "divorced")\n OR $${IFlowVar2}$$ > 40) => "Strange"\n\n The logical connectives help express complex conditions.\n \n $${SFlowVar10}$$ MATCHES $${SFlowVar0}$$ OR $${DFlowVar2}$$ < $${IFlowVar1}$$ =>\n $${SFlowVar0}$$\n\n You can compare different flow variables.\n \n The NaNs equal to other NaN values (other values are neither less, nor greater or equal to NaN values).
\n \n \n ","shortDescription":"Applies user-defined (in a table) business rules to the flow variables","keywords":[],"deprecated":false,"streamable":false,"tags":["Workflow Control","Variables"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3hpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6NDU0QTMxRkQ0NUM3MTFFNUFDNkJBNzc0MkI4RTNBMkQiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6NDU0QTMxRkM0NUM3MTFFNUFDNkJBNzc0MkI4RTNBMkQiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpiMjZmMjcxNS1kZmZiLTRlYTgtYWJjMi0xZDk4N2YzMzE1NzIiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6MGIzNmFjOTctNWViYS00MGU3LTkxODktYmJlOGQ3ZDBmMjRlIi8+IDwvcmRmOkRlc2NyaXB0aW9uPiA8L3JkZjpSREY+IDwveDp4bXBtZXRhPiA8P3hwYWNrZXQgZW5kPSJyIj8+qS97WwAAALZJREFUeNpi/P//PwNFAGpABxC/A2JBJKkzQHwXJI8PwwwwBpkFxOVQzXA+sQaAwG6orQxQg0ASSqQYkAbVBLL9LtRABlIMYICGw25k75BqwEyoZniAguSlxKQ5CMUCA1rgrcKiBkQ0YDWAUFpAMgDDEBYYA+hMATxmfIAZxMjIWA8Va0B3wX9CGAaQXcIIcz7Q5P+kJGugehDVSJELgN5mRQlEvPENNQAjICmNBVINwEgHAAEGAFcHLF4MJgTXAAAAAElFTkSuQmCC","views":[],"inPorts":[{"objectClass":"org.knime.core.node.port.flowvariable.FlowVariablePortObject","color":"ff4b4b","dataType":"Flow Variable","optional":true,"name":"Input variables (optional)","description":"Input variables (optional)"},{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Rules","description":"Table containing the rules"}],"outPorts":[{"objectClass":"org.knime.core.node.port.flowvariable.FlowVariablePortObject","color":"ff4b4b","dataType":"Flow Variable","optional":false,"name":"Output variables","description":"Output variable"}],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Options","fields":[{"name":"Dictionary mode","description":"Choose how the rules table encodes the rules.\n