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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
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.
Highlighted
Pulsar

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

Bolide
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