NULLInterpret

[srihitha]

Why is NullCount(OrderNumber) showing 0 even after using Set NullInterpret ='NULL';

NullCount(OrderNumber)  =1 is what I  am looking for in result 

Script:

NullAsValue *;
Temp:

LOAD * inline [

Customer|Product|OrderNumber|UnitSales|UnitPrice

Astrida|AA|1|4|16

Astrida|AA|A|13|15

Canutility|CC|-||19

Divadip|CC|'NULL'|4|16

] (delimiter is '|');

Set NullInterpret ='NULL';

Count1:

LOAD Count(OrderNumber),NullCount(OrderNumber)
Resident Temp;

[vinieme12 · Accepted solution]

remove NullAsValue *;

Set NullInterpret ='NULL';


Temp:
LOAD * inline [
Customer|Product|OrderNumber|UnitSales|UnitPrice
Astrida|AA|1|4|16
Astrida|AA|A|13|15
Canutility|CC|-||19
Divadip|CC|NULL|4|16
] (delimiter is '|');



Count1:
LOAD Count(OrderNumber),NullCount(OrderNumber)
Resident Temp;