Hi,
Please fill empty cells with null value.
Thanks
you can use a formula with something like this:
if isempty([field]) then null()
else [field] endif
hope it helped!
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
