[SOLVED] Nesting expressions

tmanasa
tmanasa New Altair Community Member
edited November 5 in Community Q&A
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.
Tagged:

Answers

  • Unknown
    Unknown
    Hello Ted

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

    regards

    Andrew
  • tmanasa
    tmanasa New Altair Community Member
    Thanks, Andrew. You were right about the capital "if". This works.

    if(BALANCE==0,"FULLPAYER",if(BALANCE<0,"OVERPAYER",if(BALANCE>0,"UNDERPAYER","UNKNOWN")))

Categories