10 Replies Latest reply: Apr 7, 2016 9:51 AM by florentina dogaru RSS

    Classifying nulls in a field based on another field

    neetha P

      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