i have a null values in table but i want assign all null values to a field called 'null' how to assign?

[#1]

i have a null values in table but i want assign all null values to a field called 'null' how to assign?

[its_anandrjs]

Read this documents for the NULL

[#3]

where is doc

[its_anandrjs]

Find Attached Pdf document.

[#5]

i cant find it

[selvakumarsr]

In Load Statement

if(Country=' ',  null, Country) as Country

or

Set NullDisplay = '<NULL>';

[Anonymous]

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';

[its_anandrjs]

You can find from this attached URL.

NULL handling in QlikView

Hope thus helps