Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

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

timewaste
8 - 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.

4 REPLIES 4
MarqueeCrew
20 - Arcturus
20 - Arcturus

use a multi-field formula

 

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

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Kenda
16 - Nebula
16 - Nebula

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

JoshKushner
12 - 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'
EricMartinson
7 - Meteor

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

Labels