Changing NULL values with model builder

[TanyaEsteves]

Hi.

I'm using model builder to build a tool, where at a certain point, I need to take the Z elevation values from the feature class that are NULL and turn them into the value 0 (zero). To do so, I'm using the calculate field tool. I just have a problem... I know very little of VB and NOTHING of python... I was hoping someone could help me create the appropriate code to change the values I need?

I'm guessing it should be something very simple... like an if..then statement? Something like: if Z=Null then Z=0. I just need to "translate" it into programming language.

Any help... please?

Thanks in advance.http://forums.arcgis.com/images/icons/icon7.png

[JimCousins]

The correct syntax for the NULL keyword is:
"Z" IS NULL
do not use the "=" with NULL.
Regards,
Jim

[TanyaEsteves]

Well, so far I got:

Dim Z
If IsNull () = "True" then
= 0
End if

But it doesn't work... any suggestions?

Thanks.

[RichardFairhurst · Accepted solution]

Well, so far I got:

Dim Z
If IsNull () = "True" then
= 0
End if

But it doesn't work... any suggestions?

Thanks.

To do this you need to check the codeblock checkbox.  You also have to handle the situation where the Z field has a value and is not Null.  Finally you cannot use a field name as the output of the calculation only a variable which is only resolved to a specific field by doing the calculation on a given field.

Parser:  VBScript

Prelogic codeblock:

If IsNull() Then   Output = 0 Else   Output =  End If

Expression:  Output

[TanyaEsteves]

Dear rfairhur24,

Thank you so much for your help. It worked perfectly!! I really need to get my head around programming!! http://forums.arcgis.com/images/icons/icon11.png

Best wishes.