1 Reply Latest reply: Apr 9, 2018 11:22 AM by Digvijay Singh RSS

    Load Value by max Date

    Erica Trotter

      Hello,

      I am trying to load Pay rate by max modification date, but it doesn't seem to be working correctly:

       

      NoConcatenate

      Compensation:

      LOAD AgentID,

           Maxstring(ModificationDate) as ModificationDate,

           Max(PayRate) as PayRate

      Resident Compensation_Temp

      Group by AgentID;

       

      I want one payrate per AgentID, here is the current output:

      Capture.PNG

       

      Let me know if you can help!