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
With Column Expressions node you can do anything!
But I think Rule Engine node can handle this problem too.
and welcome to KNIME Community!
Rule Engine node can not handle mathematical operations and you would probably have to follow it with Math Formula node to calculate prediction.
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.