3 Replies Latest reply: Nov 5, 2013 5:27 AM by Vivienne Sacco RSS

    How do I include only certain rows in a load script?

      Hi all,

      I'm new to Qlikview scripting and have found the forum invaluable for helping me overcome problems but I can't find an answer to this one. I have an input table that looks similar to this:-

       

       

      Transaction RefAction DescriptionAction Date
      AREFUND01/03/2013
      BSWAP02/03/2013
      AREFUND05/03/2013
      BREFUND08/03/2013
      ACANCEL06/03/2013
      BSWAP08/03/2013
      ACANCEL12/03/2013

       

      I would like to load only the most recent date for each unique combination of Transaction Ref & Action Description so that the table loaded looks like this:-

       

      REFUNDCANCEL
      Transaction RefAction DescriptionAction Date
      A05/03/2013
      A12/03/2013
      BREFUND08/03/2013
      BSWAP08/03/2013

       

      Any help or hints on how I should script this would be really appreciated.

      Many thanks