on 10-11-2016 10:55 AM - edited on 07-27-2021 11:36 PM by APIUserOpsDM
How To: Create Null Values in Data
In processing and formatting your data, you may decide that some records should be classified as Null values. Rather than fill in numeric fields with a 0 or leave a field empty (‘’), a Null value may be the best option for analyzing and storing your data.
Procedure
How to do this for in db?
is it possible to convert every empty cell in my database to [null]?
Thanks, Joe! I was using IF ([CurrentField_])="" THEN Null(), which I guess is different than "IsEmpty". Thanks again!
NULL() did not work in in-DB formula.
For In-DB, use NULL instead.
In-DB uses whatever syntax the DB itself requires (because it just sends SQL to the DB server to execute) - so you'd need to look up the help pages to find an ISNULL-equivalent function for TSQL for MS SQL Server, IBM for Netezza, etc depending on what you're working in.
(P.S. Thanks for the multi-field formula! I spend most of my time using in-DB, so need to use the forum to learn the Alteryx syntax and tools!)