Don't forget to register for our panel discussion with Dean Stoecker, Amy Holland, and Mark Frisch occurring next Wednesday, June 1!

2022-05-26 Updates: Email: If you're not seeing emails be delivered from the Community, please check your spam and mark the Community emails as not junk. Thank you for your patience.

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

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
19 - Altair
19 - Altair

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
15 - Aurora
15 - Aurora

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