Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have a null values in table but i want assign all null values to a field called 'null' how to assign?
Read this documents for the NULL
where is doc
Find Attached Pdf document.
i cant find it
In Load Statement
if(Country=' ', null, Country) as Country
or
Set NullDisplay = '<NULL>';
Hi,
If you want to specify NULL for all columns available in your schema than below script will solve your issue.
SET NulLDisplay ='NULL';
If you want to display NULL for only specific columns than below script should work,
NullAsValue <ColumnName1>, <ColumnName2>;
SET NullValue='NULL';