topic ArcGIS Pro 3.0.2: How to replace the records of “null” value with zero with a tool in model builder? in ArcGIS Pro Questions

ArcGIS Pro 3.0.2: How to replace the records of “null” value with zero with a tool in model builder?

JamalNUMAN — Fri, 01 Dec 2023 10:34:23 GMT

ArcGIS Pro 3.0.2: How to replace the records of “null” value with zero with a tool in model builder?

In the screenshot below, the “percent” field has records of “null” value. What could be the best way to replace these values with zero with a tool in model builder?

Re: ArcGIS Pro 3.0.2: How to replace the records of “null” value with zero with a tool in model builder?

DuncanHornby — Fri, 01 Dec 2023 14:23:07 GMT

I would feed that table into a select by attribute tool and select rows where Percent Is Null. The output of that tool is a table\featureclass with a selection, that simply feeds into a calculate field tool and you set it to zero. Remember all geoprocessing tools honour selections first, if nothing is selected then the whole dataset is processed.

Re: ArcGIS Pro 3.0.2: How to replace the records of “null” value with zero with a tool in model builder?

DanPatterson — Fri, 01 Dec 2023 18:37:40 GMT

You already have a calculate field in your model.

Did the calculation incorporate checking for Null? If it did, you could assign a 0 value.

for example conceptually

if A is None, or B is None:

return 0

else:

return A/B * 100

Re: ArcGIS Pro 3.0.2: How to replace the records of “null” value with zero with a tool in model builder?

JamalNUMAN — Fri, 01 Dec 2023 18:41:34 GMT

I wanted to replace the records of “null” value with zero BUT to keep the same number of records (which is 253 records) of the attribute table. How this can be performed optimally?

Re: ArcGIS Pro 3.0.2: How to replace the records of “null” value with zero with a tool in model builder?

DanPatterson — Fri, 01 Dec 2023 21:33:46 GMT

What is the expression that you used in "calculate field" ?

Re: ArcGIS Pro 3.0.2: How to replace the records of “null” value with zero with a tool in model builder?

JamalNUMAN — Fri, 01 Dec 2023 22:18:09 GMT