How to fill columns

[Nury]

Hello,
I have question.
I have 3 columns, If in mandatory column is “yes” I have to fill stock number in the next column, if “no” I have to put 0 in the next column also. So it should be like on the second form. How I can do it on Knime? If somebody knows please let me know.

Thanks in advance!

[ipazin]

Hello @Nury,

one way to do it is with Rule Engine:

Rule Engine

Should be pretty easy so give it a try and if any issues someone will assist you

Br,
Ivan

[Nury]

Thank you, Ivan.

I know the node, but I don’t know which code will make it.
$Mandatory$ = “yes” => $Stock$
$Mandatory$ = “no” => “0”

And this one is not work.

[ipazin]

Hello @Nury,

what is output of your rules? Seems to me they should work according to data you have showed us. Can you shows us how does your data look like in KNIME?

Br,
Ivan

[Nury]

Oh yeah, it’s work now, I just delete and put rule engine again. Thanks for advice!

[ipazin]

Glad to hear that @Nury.
Possibly there was an error with previous rules
Ivan