SOLVED
Convert Empty String Columns to NULL for Many Columns
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
AndrewJacksonZA
6 - Meteoroid
‎10-24-2018
02:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Parse
- Tips and Tricks
- Transformation
2 REPLIES 2
LordNeilLord
15 - Aurora
‎10-24-2018
02:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Have a look at the multifield formula tool...with the formula: if IsEmpty([_CurrentField_] Then Null() Else [_CurrentField_]
‎10-24-2018
02:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you @LordNeilLord, that solved the issue. :-)
