Classifying nulls in a field based on another field

[Anonymous]

Hi All,

Please any help will be appreciated.

I am trying to Classify nulls in a field based on another field with below script:

LOAD
Rank,
If(Match(Rank, '1','2', '3'),'VP',
If(Match(Rank, '4', '5'),'Dir',
If(Match(Rank, '6','7'),'Mgrs', 
If(Match(Rank, '8', '9','10'),'Prof',
if(Match(EMP_TYP,'Reg','Temp ') and Rank = 'UNDEFINED','Undefined Emp',
if(Match(EMP_TYP,'CW') and Rank = 'UNDEFINED','Undefined CWs','UNDEFINED')))))) as [RANK DESC]
Resident EmployeeData;

Unsuccessful, because its taking all nulls count for each classification, instead of count for each classification.

Thanks & Regards

Neetha

[florentina_doga]

add a field in load like

recno() as no_