RULE for choosing column

Hey there

I am looking for a solution to this
A table with different products (fruits or vegetables). There are two cost columns for fruits or vegetables.
Now I am looking for a RULE that writes to a new column relevant cost information.
Usually for fruit > cost fruit and for vegetable > cost vegetable.
But if cost for fruit is “0” cost information should be taken from cost vegetable column.
Would that work in any way?

Thanks so much.
Best Jules


Hi @JulesFS

your use this code in rule engine node:
$csot fruit$ =0 => $cost vegetable$
TRUE => $csot fruit$


Hello @JulesFS,

and welcome to KNIME Community!

Apart from Rule Engine you can also use Column Aggregator node with Maximum aggregation method.


1 Like

Dear mehrdad_bgh and ipazin

Thank you so much for your very helping comments :+1:

Worx !


This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.