Improvements on Data Cleansing Macro

[JorisLimousin]

Hi there,

Just a quick note on a really small improvement that could be made on the Data Cleansing tool but that could help a lot.

Actually this tool allows us to convert input data with NULLs to either blank or 0 values depending on the datatype.

It would be really appreciated to be able to do the opposite, converting blank or 0 values to NULLs.

[MacRo]

Hey @JorisLimousin -- I'm not a project manager here, so I can't comment on potentially adding this as a feature to the cleanse tool, but just wanted to offer a solution for you in the meantime. You can accomplish this by using the following expression in a Multi-Field Formula tool: iif([_CurrentField_]=0,null(),[_CurrentField_]) If you use this approach, simply select the fields you want to replace and *uncheck* the option "Copy Output Fields and Add [...]". This will replace 0's will null values. You can do the same for empty strings by replacing =0 in the expression above with =""

[JorisLimousin]

Hi MacRo,

Thank you very much for your answer, actually I already did exactly what you say. :P

It was more about posting this as an idea that could potentially be implemented and could be beneficial to everyone in the Alteryx community.

But thank you again for providing this answer, I'm sure it will help people trying to do the same thing!

[Community_Admin]

The status of this idea has been changed to 'Inactive'. This status indicates that:

1. The idea has not had activity in the form of likes or comments in over a year.

2. The idea has not reached ten likes.

3. The idea is still in the 'New Idea' status. 

However, this doesn't mean your idea won't be implemented! The Community can still like and comment on this idea. With enough renewed interest, this idea can be brought back into the 'New Idea' status. 

Thank you for contributing to the Alteryx Community and the Alteryx Product Idea Boards!