AnsweredAssumed Answered

ArcGIS Pro 2.4 | How to replace Null values (stored in number fields) to 0 for field calculation?

Question asked by Vincenty on Oct 10, 2019
Latest reply on Oct 14, 2019 by bixb0012

Hi,

 

Data in FGDB have Null values by default in numeric fields. When performing calculation, it cannot sum fields where Null values occur.

 

My question is how to replace all Null values to 0 - in several/all numeric fields - in one go?

 

Or, potentially, I can use the Calculate Fields tool but what could be an expression to replace Null to 0 on a single line (cannot use expression on multiple line with this tool) ?

On single line, I tried:

 

if None: 0

if Null: return 0
if None: return 0
replace(Null, 0)

 

...obviously, none worked!

 

Thanks

Outcomes