Hello
This question is related: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Empty-to-Null/td-p/73681
I have many fields that I need to convert to NULLs if they are empty strings. Is there an easier and more time-efficient way to do that other than running a formula against each and every field in the formula tool?
I looked at the data cleansing tool but it goes in the opposie direction, NULLs to empty strings.
Thank you Andrew
Edit: Why was all the formatting stripped out?
Solved! Go to Solution.
Have a look at the multifield formula tool...with the formula: if IsEmpty([_CurrentField_] Then Null() Else [_CurrentField_]