Fill Nulls in empty cells

[amitsingh145]

Hi,

Please fill empty cells with null value.

Thanks

[Ladarthure · Accepted solution]

Hi, 

you can use a formula with something like this:

if isempty([field]) then null()

else [field] endif

hope it helped!

[TomWelgemoed]

Hi, 

Know this is solved, but please note that there is a shortcut for doing this for multiple columns: you can use the multi-field tool and apply this across your entire dataset (!) . 

Your formula will then just be needed once, and looks like this:

if isEmpty([_CurrentField_])
then NULL()
else [_CurrentField_]
endif

Regards,

Tom