community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

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

Asteroid

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.

Alteryx Certified Partner
Alteryx Certified Partner

use a multi-field formula

 

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

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Pulsar
Pulsar

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

Highlighted
Quasar
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'
Labels