Convert Empty String Columns to NULL for Many Columns

[AndrewJacksonZA]

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?

[LordNeilLord · Accepted solution]

Hi @AndrewJacksonZA

Have a look at the multifield formula tool...with the formula: if IsEmpty([_CurrentField_] Then Null() Else [_CurrentField_]

[AndrewJacksonZA]

Thank you @LordNeilLord, that solved the issue. :-)