How to use if statement in attribute generation?

User: "habib_ahmed89"
New Altair Community Member
Updated by Jocelyn
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

Find more posts tagged with

Sort by:
1 - 1 of 11
    User: "Marco_Boeck"
    New Altair Community Member
    Hi,

    the syntax is:

    if(missing(field1)==false,field1,field2)
    Regards,
    Marco