making NULL value into N

[#1]

Hi,

I have a lot of NULL values in my table.

Is there any way I can make NULL into N?

Thank you!

[andrespa]

Hi David, maybe something like this:

NullMap:

MAPPING LOAD

'',

'N';

TABLE:

LOAD *

ApplyMap('NullMap', YourField)

FROM [YourPath]

Hope it helps,

Andrés

[andrespa]

Hi David, just a corrrection.

NullMap:

MAPPING

LOAD Map,

     Con

FROM

[YourPath\NullTesting.xlsx]

(ooxml, embedded labels, table is Hoja2);

TABLE:

LOAD *

ApplyMap('NullMap', YourField,YourField)

FROM [YourPath]

And the mapping table works if you build something like this in for example an excel:

Map	Con
	N

And then load it as I told you before in the NullMap.

Cheers,

Andrés

[tamilarasu]

You can replace your expression in chart like below,

=If(IsNull(FieldName),'N', FieldName)

[Anonymous]

Hi,

you can try =if(isnull(<fieldName>),'N',<fieldName>) if the field has a null value

[#6]

Hi david,

in your table if you have  'NULL'

try like this

if(yourfieldname='NULL','N',yourfieldname) as new

or

if you have blank like( )

try like this

if(len(yourfieldname)<1,'N',yourfieldname) as new1

[settu_periasamy]

If you want to do it in Script Lever, Try this..

SET NullValue = 'N';
NullAsValue *;  // You can give the listed field names instead of * (All fields) 

[Chanty4u]

u can replace  in script  as

set nullvalue='N';

nullasvalue*;

it will work

[Kushal_Chawda]

There are several ways of doing it. Please go through the below link which is having document attached

NULL handling in QlikView

[buzzy996]

can u try tis?