This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I've always wondered why the Data Cleansing tool has the option to convert nulls to blanks, but not convert blanks/empty cells to null.
I'm sure it's debatable given different approaches, but we always look to convert blank/empty data strings to NULL. Currently I have to do an extra cleansing step via a formula tool anytime I want to clean up these blanks.