topic Re: Replace nulls with 0 in Alteryx Designer Desktop Discussions

Replace nulls with 0

AustinBauer — Tue, 25 Sep 2018 17:10:39 GMT

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.

Re: Replace nulls with 0

MarqueeCrew — Tue, 25 Sep 2018 17:29:59 GMT

@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

Re: Replace nulls with 0

BenMoss — Tue, 25 Sep 2018 17:33:40 GMT

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