1

I'm making this model that modifies the table that I show:

MODEL.PNG + TABLE.SHP + TABLE.PNG

(I'm sending it this way because the network I'm using have limited access and this is my only option)

The next step is selecting the values from "FECHA_2" that are lower than the value in "FECHA_MIN" for later calculate another field

One of the ideas I have is to fill all the Null values in the field "FECHA_MIN" with the only value I have, but I don't know how to do it in ModelBuilder, so I'm looking for a way to solve this or another idea to make the selection.

1

From ModelBuilder, to change the null values : Insert >> Iterator >> Field values

Then connect your feature that has null values, change the setting of the iterator to your value for the null value field

Please check the attached image

enter image description here

enter image description here

Also, you can do it without iterator, using Calculate field but here you will use python for changing the values, something like:

def updateValue(value):
  if value == 'Null':
   return 'yourvalue'
  else: return value

updateValue(!YourColumn_name!)
  • But in this case would I have to enter the new values of NULL manually? If it is possible I would like the model to do this acutomaticly, because the model needs to run with other tables that have different values – Carolina Tello Feb 14 '18 at 0:16
  • So is the value to replace with null is the same (e.g one value for all the nulls)? and would you get this value from another (one table)? or different values from many tables? – Moh Feb 14 '18 at 0:25
  • I would have different values from many tables – Carolina Tello Feb 14 '18 at 17:03
  • I am not sure if you will be able to do that with ModelBuilder for the reason of multi-values from multi-sources and null values in unknown rows – Moh Feb 14 '18 at 19:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.