Attribute Construction

Legacy UserLegacy User Member Posts: 0 Newbie
edited November 2018 in Help
I would like to calculate a turnover figure. I have the sales quantity and two different price attributes. All three atrributes are numerical(real) attributes. Based on a nominal indicator (has two possible values: A or C) I would like to decide the appropriate formula.
Unfortunately the AttributeConstruction operator. I have entered if(indicator == A, salesquantity*price1,salesquantity*price2) is not working. I always get the message: Unrecognized symbol "V".
Any ideas?

Answers

  • landland RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 2,531 Unicorn
    Hi Alexander,
    try using if(indicator == "A", salesquantity*price1,salesquantity*price2).

    The operator info states:
    Beside those operators and functions, this operator also supports the constants pi and e if this is indicated by the corresponding parameter (default: true). You can also use strings in formulas (for example in a conditioned if-formula) but the string values have to be enclosed in double quotes.
    To read it, use the context menu in the operator tree or press F1.

    Greetings,
    Ā  Sebastian
Sign In or Register to comment.