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
