🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

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