Hi all,
How to find the write a condition if column1 is blank then give me the next column2 now if comlun2 is still blank then give me column3. Now if all column its still blank then give me column1.
Thank You,
@rmartinez4 You can write something like the below. If it is not working please provide some sample data and expected output
May be a slightly drawn out way of doing it, but the following approach ought to be dynamic if you were to add any amount of fields to this i.e. if you had 1,000 columns and just needed to return the first non-null.
Do you have only 3 columns, or more than 3?
Use the Formula tool to create a new field
IF IsEmpty([my field 1]) and IsEmpty([my field 2]) AND IsEmpty([my field 3]) THEN Null()
ELSEIF IsEmpty([my field 1]) THEN [my field 2]
ELSE [my field 1]
ENDIF
