Python Field Calculator Null Values

Question

I am trying to calculate the value of a field based on multiple other fields. My code works fine in Python, but it bombs in ArcPad. The reason must be that I have Null values in a lot of my fields.

Here is a very simplified illustration:def main (a,b):
  return a

field1 =  main(1, !field2!)

where !field2! is a field that is Null

I receive no error, it just won't place the calculated "1" into field2. If you were to put:

field1 = main(1,2)

or
field1 = main(!field3!, !field4!)

with field3 and field4 holding a non null value, the calculator works as expected. I can't even test for Nulls b/c Python in the Field Calculator apparantly doesn't allow you to access the fields directly in the Codeblock like VBScript would.

Has anyone else ran into this? This seems like it would be a fairly common issue.

JasonTipton · Answer

Yes, I'm on 10 SP3 and it seems to be fixedIsn't it this behavior?

NIM059424 - Null values in the feature class do not get replaced when using Python in the Field Calculator.

Seems to be fixed in 10.1.

I don't really use python with the field Calculator anymore, though. I had to switch to using cursors to get around the issue and haven't looked back. If you're going to go through all the trouble to create some code, might as well do it up right.

ZdeněkJankovský · Answer

Isn't it this behavior?

NIM059424 - Null values in the feature class do not get replaced when using Python in the Field Calculator.

Seems to be fixed in 10.1.

DavidStrip · Answer

I just ran into this now. While I think I understand your solution, this seems like an odd behavior for the design of the Field Calculator. I would consider it a bug. Perhaps someone at ESRI can explain the reasoning for this behavior?