Hi I just have a problem removing the null values in a date format type of data. I already used the data cleansing tool but the null values remained. Can you help me solve this problem? Is there any tool to replace the null values into blank ?
@dunkindonut7777 You can do that. See attached sample.
Hi @dunkindonut7777,
If your data type is a date then you will not be able to change it to blank unless you will change it to a string.
I have tested it myself and after that I checked the formula and it confirmed my previous test:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Replace-nulls-in-DateTime-field-with-blank-empty/m-p/316875/highlight/true#M57615
