Null output from field calculator code block

Question

I have a simple calculation to compare two columns and populate a new column with the lower value but I am getting null output...any ideas?

expression

re_score(!Signal_Strength!,!Signal_Strength_1!,out1)

code block

out1='99'
def re_score(f1,f2,out1):
 if f1<f2:
  out1 = f1
 else:
  out1=f2
 return out1

WARNING 000405: No records within table Succeeded at Tue Mar 06 15:13:45 2012 (Elapsed Time: 7.00 seconds)

Mike T · Accepted Answer · 2012-03-06 05:39:48Z

3

You can evaluate your expression using a simple inline-if statement (does not require codeblock):

!Signal_Strength! if !Signal_Strength! < !Signal_Strength_1! else !Signal_Strength_1!

Or rework your codeblock:

def re_score(f1,f2):
    if f1 < f2:
        out1 = f1
    else:
        out1 = f2
    return out1

with expression:

re_score(!Signal_Strength!, !Signal_Strength_1!)

answered Mar 6, 2012 at 5:39

Mike T

42.7k10 gold badges132 silver badges194 bronze badges

1 Answer 1