grouping with Rule Engine

[aehrenworth]

Think this is a basic use of the Rule Engine — however, what do I need to adjust to make sure this new column is producing the correct buckets. Right not it is ONLY producing one match even though I know there is variation in the column.

Is there a different node that would work better?

$Over Limit$ >=0 AND $Over Limit$ <= 50 => “0-50”
$Over Limit$ >=50 AND $Over Limit$ <= 100 => “50+”
$Over Limit$ >=100 AND $Over Limit$ <= 200 => “100+”
$Over Limit$ >=200 AND $Over Limit$ <= 500 => “200+”
$Over Limit$ >=500 AND $Over Limit$ <= 1000 => “500+”
$Over Limit$ > 1000 => “1000+”

[mlauber71]

@aehrenworth the Rule Engine is perfectly fine. Maybe you check your data. Also your definitions have overlapping rules. KNIME will choose the first rule that matches

Rule Engine - KNIME Forum (83998).knwf (76.8 KB)

[HansS]

Hi @aehrenworth

You can also add an extra rule, to identy records that are not covered by your rules, add:

TRUE => “I need to check this”

gr. Hans

[ArjenEX]

Speaking of those rules, be mindful that you have multiple conditions covering the same value and only the first occasion will be used as output. Like <= 50 and >=50. Based on your output value I’d make it >50 instead.