Data Cleansing

Question

I have a column with a mix of numbers and Null values but the Data Cleansing tool does not replace the nulls with 0 when I select this option. It stays null. Any idea how I can resolve? The Data Cleansing tool is working for other parts of my workflow but not this column.

ChrisTX · Accepted Answer

What is the data type?  The option for Replace Nulls says "Replace with 0 (Numeric fields)"

shancmiralles · Accepted Answer

hi ! use a select tool first and and change the column type to a number type.. in this way data cleansing tool will acknowledge  the column as a number column and any blank cell will have zero (0).

ChrisTX · Accepted Answer

A "blank" value is different from a Null value.  Data Cleansing will only replace Null values.

TUSHAR050392 · Accepted Answer

Since you have null values in the column, alteryx is considering it as string data type. Use a select tool to change the data type to number and then use data cleansing tool. Hope this explains the reason and resolves the issue.