IF statement with AND nested

KNIME Analytics Platform
1

Hi Knimers,

I would like to perform the following action.

col1 col2 col3
? ? 3
1 ?

2

 

I want to find a node or write something like that:

IF Col1="?" AND col2="?", THEN create a new column eg. Col4=Col3 and plug in the content of Col3.

How is this possible to happen in knime. I took a Math formula Node that has an IF statement but it doesnt seem to accept AND &.

Looking forward to a reply.

2

You need the rule engine node. It can do exactly this.

Best, Iris

3

thank you iris.