Solve for isNull across multiple columns at once

I have a number of columns with null values. Is there a simple way to replace all nulls in certain columns without doing a separate formula for each column? I do not want to create any new columns.

Example:

Column A / Column B / Column C - if any of the values in column A, B, or C are null, then replace with 0 in that original column of data

Thank you in advance!

Tips and Tricks

Optimization

Accepted answers

Luke_C

Hi @ewall

You could use a data cleanse tool or a multi-field formula tool. I would recommend the latter, it would look something like this:

The key thing is to uncheck the box for copy output fields.

Jonathan-Sherman

Hi @ewall,

I'd go for the data cleansing approach as it's the simplest method:

Before:

After:

I've attached my workflow for you to download if needed!

Kind regards,
Jonathan

20210525 - NullToZero.yxmd

Jonathan-Sherman

Just to add a bit of background for @ewall...to decide on the approach i'd ask myself a question...

Do these columns (and will they always) contain only numeric values. If so then data cleansing works perfectly, if not then you'd need to go down the route of the multi-field formula tool as the data cleansing tool would convert null values to blanks in columns that have non-numeric data types

Kind regards,

Jonathan

All comments

Luke_C

Hi @ewall

You could use a data cleanse tool or a multi-field formula tool. I would recommend the latter, it would look something like this:

The key thing is to uncheck the box for copy output fields.

Jonathan-Sherman

Hi @ewall,

I'd go for the data cleansing approach as it's the simplest method:

Before:

After:

I've attached my workflow for you to download if needed!

Kind regards,
Jonathan

20210525 - NullToZero.yxmd

apathetichell

One addendum to what @Luke_C said - if the columns are numeric - datacleanse does everything for you when you check "replace with 0 (numeric fields) - but we all like the tools we like.

Jonathan-Sherman

Interesting @Luke_C, that we both went for the opposite approach!

aghftec

Hi all, what should I do if I want to Backward/Forward fill all the null values in multiple columns?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703