RULE for choosing column

[JulesFS]

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

[mehrdad_bgh]

Hi @JulesFS

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

[ipazin]

Hello @JulesFS,

and welcome to KNIME Community!

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

Br,
Ivan

[JulesFS]

Dear mehrdad_bgh and ipazin

Thank you so much for your very helping comments

Worx !