In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Convert Empty String Columns to NULL for Many Columns

AndrewJacksonZA
6 - Meteoroid

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?

2 REPLIES 2
LordNeilLord
15 - Aurora

Hi @AndrewJacksonZA

 

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

AndrewJacksonZA
6 - Meteoroid
Thank you @LordNeilLord, that solved the issue. :-)
Labels
Top Solution Authors