6 Replies Latest reply: Feb 3, 2015 10:36 AM by Clever Anjos RSS

    Load only latest records?

    Vidit Saxena

      Hi,

      i have the following table

      EmpDeptcreditEffective_dt
      A10A101/1/2015
      A12A2001/12/2014
      A9B3001/11/2014
      B10A902/10/1999
      B9B801/9/2014
      C9B251/1/2014

       

      Out of which i want to load only the latest record for each of the employee in qlikview.

      i.e

      the table has all historical data, out of which i want to fect latest record for each employee.

      the desired table should have the following records

      EmpDeptcreditEffective_dt
      A10A101/1/2015
      B9B801/9/2014
      C9B25

      1/1/2014

       

      Kindly suggest the script.

       

      Regards

      Vidit