I created a CSV file from Script where I get something like:
As you can see, I have some empty values without Zones, like Account 03.
Then I load this file as a table and I get an Empty/Blank value for some Zones.
Is there any way to convert those blank into null or something else? How can I do?
maybe (replace inline load with your real file)
load * inline [
if(len(trim(Zone))=0, 'zone is empty', Zone) as Zone,
drop table file;
Update now check please
You can add null values in the blank values see the example load
LOAD * Inline
Account,if(Len(Zone) = 0, Null(),Zone) as Zone,Date
DROP Table tmp;
Try near the top of the script:
Set NullInterpret = '';