How to use if statement in attribute generation?

habib_ahmed89

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

Marco_Boeck

Hi,

the syntax is:

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

Regards,
Marco