Formula Tool - Replace NULL in all columns(350 columns) with 0

[timewaste]

Hello,

May I please know a way to write a formula to search for NULL in all columns(350) of the data and replace it with 0 at once. 

Thanks in advance.

[MarqueeCrew · Accepted solution]

use a multi-field formula

IIF(IsNull([_CurrentField_]),0,[_CurrentField_])

Cheers,

Mark

[Kenda · Accepted solution]

Hey @timewaste! You could either use the Multi-Field Formula Tool or the Data Cleansing Tool. Hope this helps!

[JoshKushner · Accepted solution]

You can use the 'Data Cleansing tool' or 'Imputation tool' for this.

Data Cleansing:
-In the 'Replace Nulls' group check the box 'Replace with 0. FYI: this will only work for numeric fields

Imputation:
-In the 'Incoming value to replace' group select 'Null()'. In the 'Replace with Value' group select 'User specified Value' and set that to '0'

[EricMartinson]

Thank you for posting @MarqueeCrew! This 3 year old post solved a similar issue for me!