Pages: [1]
  Print  
Author Topic: How to use if statement in attribute generation?  (Read 346 times)
Red
Newbie
*
Posts: 2


« on: July 19, 2013, 01:04:41 AM »

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
Logged
Marco Boeck
Administrator
Hero Member
*****
Posts: 961


WWW
« Reply #1 on: July 19, 2013, 07:24:20 AM »

Hi,

the syntax is:
Code:
if(missing(field1)==false,field1,field2)

Regards,
Marco
Logged

Pages: [1]
  Print  
 
Jump to: