nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

JamalNUMAN

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?

Trouver plus de publications taguées avec

Accepted answers

DanPatterson

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

All comments

Hornbydd

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.

DanPatterson

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

JamalNUMAN

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?

DanPatterson

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

JamalNUMAN

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.