Replace nulls with 0

[AustinBauer]

I'm trying to replace nulls in certain columns with 0 using the data cleansing tool. However, it is creating extra rows at the bottom of my data set with 0's. Is there a way to make this not happen. See picture. 

[MarqueeCrew · Accepted solution]

@AustinBauer,

Your incoming data likely has NULL row data (e.g. from Excel).  Please try to FILTER the data where !IsEmpty([Field1]) might do the trick (field1 would be a field that ALWAYS has good data in it).

After that you can use the data cleansing tool or a MULTI-FIELD FORMULA to replace Null values with 0.

Cheers,

Mark

[BenMoss]

I can't say I've ever seen this issue before, could you share a workflow with non sensitive data where this issue is replicated.

As an alternative you can use the multifield formula tool to do this.

Here you would select the fields you wish to convert, unselect the option to create a copy and rename as. And then give the statement...

If isnull([_currentfield_]) Then 0 else [_currentfield_] endif

Ben