The Altair Community is migrating to a new platform to provide a better experience for you. The RapidMiner Community will merge with the Altair Community at the same time. In preparation for the migration, both communities are on read-only mode from July 15th - July 24th, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here.
Options

How to use if statement in attribute generation?

habib_ahmed89habib_ahmed89 Member Posts: 2 Contributor I
edited November 2018 in Help
Hello, I have a simple issue of comparing 2 fields and getting the value of the one that isn't null, with priority on one field

My statement looks like
if(field1 != null, field1, field2)

However, it seems my condition is not correct. What is the way to find nulls in this type of expression?

Thanks

Answers

  • Options
    Marco_BoeckMarco_Boeck Administrator, Moderator, Employee, Member, University Professor Posts: 1,996 RM Engineering
    Hi,

    the syntax is:

    if(missing(field1)==false,field1,field2)
    Regards,
    Marco
Sign In or Register to comment.