Options

[SOLVED] Nesting expressions

tmanasatmanasa Member Posts: 13 Contributor II
edited November 2018 in Help
How do you nest IF-THEN-ELSE statements in a function expression?

I tried the following but get a syntax error.

if(BALANCE==0,"NONE",if(BALANCE<=-100,"HIGH",IF(BALANCE>0,"OVERPAYER","UNKNOWN")))


Error: Encountered " ", " ", "" at line 1, column 58. Was expecting one of: ">" ... "" ... "==" ....... etc etc.

Trying to do this in a Generate Attribute to create labels.

RapidMiner 6.0.0.001.

Answers

  • Options
    awchisholmawchisholm RapidMiner Certified Expert, Member Posts: 458 Unicorn
    Hello Ted

    It might be the uppercase IF - change it to lower case.

    regards

    Andrew
  • Options
    tmanasatmanasa Member Posts: 13 Contributor II
    Thanks, Andrew. You were right about the capital "if". This works.

    if(BALANCE==0,"FULLPAYER",if(BALANCE<0,"OVERPAYER",if(BALANCE>0,"UNDERPAYER","UNKNOWN")))
Sign In or Register to comment.