Data Cleansing

[apmaggard]

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 solution]

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

[shancmiralles · Accepted solution]

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 solution]

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

[TUSHAR050392 · Accepted solution]

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.

[apmaggard]

Thank you, all. This is resolved per all of your suggestions!