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

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

    the syntax is:

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