Which node to use for Mathematical Operations + Conditions Together

[stefenrosario]

Hi,

In my Columns I have the following columns

institutiontype - text
someamount - double
multiplier - double

I want to get the prediction(output) as :

if institutiontype = “abc,efg,xyz,lmn” then prediction = someamount * multiplier
else if institutiontype = “yyy,eyy,yyz,lyy” then prediction = someamount * multiplier
else if institutiontype = “aaa,bbb,ccc” then prediction = someamount * multiplier
else prediction = 0

[mehrdad_bgh]

Hi @stefenrosario

With Column Expressions node you can do anything!
But I think Rule Engine node can handle this problem too.

GL,
Mehrdad

[ipazin]

Hello @stefenrosario,

and welcome to KNIME Community!

For a one node solution you are looking for above mentioned Column Expressions node which is based on JavaScript syntax. See workflow example here:

If Else in Column Expression – ipazin

Rule Engine node can not handle mathematical operations and you would probably have to follow it with Math Formula node to calculate prediction.

Br,
Ivan