2 Replies Latest reply: Jul 17, 2017 12:13 PM by Piet Hein van der Stigchel RSS

    if null not working

    Chris Witman

      Approval Table Loaded Table

      Computer NameEmployeeIDAccess Level
      A1001234Admin
      B1003456Admin
      C1003667

      Admin

       

       

      Access Table Load table

      Computer NameEmployeeID
      A1001234
      B1003456
      C1003667
      D1001567

       

      Access Validation (In App Join Table)

      Computer NameEmployeeIDAccess Level
      A1001234Admin
      B1003456Admin
      C1003667

      Admin

      D1001567

       

      The problem is I want the null access level fields to say 'no approval' so i can filter by this.

       

      I have tried if(isnull([Access Level]), 'No approval', [Access Level].  This does not work.

        • Re: if null not working
          Sunny Talwar

          Are you doing this after the join has taken place (in a resident load)? If not, then that's where you need to do this....

           

          Approval_Temp:

          LOAD [Computer Name],

               EmployeeID,

               [Access level]

          FROM ....;

           

          Join (Approval_Temp)

          LOAD [Computer Name],

               EmployeeID

          FROM .....;

           

          Approval:

          LOAD [Computer Name],

               EmployeeID

               If(Len(Trim([Access level])) > 0, [Access level], 'No Approval') as [Access level]

          Resident Approval_Temp;


          DROP Table Approval_Temp;

          • Re: if null not working
            Piet Hein van der Stigchel

            Try with

             

            if(Len(Trim(([Access Level])))=0, 'No approval', [Access Level]