How can I use more than 1 conditions in an IF statement to create a new attribute?

scoopedscooped MemberPosts:1Newbie
I use if(contains("SCOOP EGG",[subclass_english]),1,0) but I also want the result to come out to be 1 if there are other conditions like SCOOP EGG PAPER, PLANTS, BALLOONS within the same statement

Answers

  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified ExpertPosts:953Unicorn
    Hi!

    Generally, can use the && operator for a logical AND and || for a logical OR concatenation of your conditions.

    So the expression would be something like
    if(contains(...) || contains(...) || contains(...), 1, 0)

    But if() in Generate Attributes has three parameters anyway, so you can put your conditions inside the if() if you want.

    if(contains(...), 1,
    if(contains(...), 1,
    if(contains(...), 1,
    0
    )
    )
    )

    Regards,
    Balázs
Sign InorRegisterto comment.