8 Replies Latest reply: Oct 8, 2017 11:38 AM by beck bakytbek RSS

    LastValue ()

    beck bakytbek

      Hi Folks,

       

      i got a situation, my table does look like:

       

      TARIF, DATUM, ANSATZ

      5, 07.03.2011, 100

      5, 01.03.2009, 70

       

      my expected output  only is:

      5, 07.03.2011, 100

       

       

      in th script area i am using this code:

      TEST:

      Load

      TARIF,

      ANSATZ,

      lastvalue(DATUM) as DATUM

      Resident TEST1 group by TARIF,ANSATZ;

       

      after reload i am still having:

      TARIF, DATUM, ANSATZ

      5, 07.03.2011, 100

      5, 01.03.2009, 70

       

      how to solve this situation, to have only this result:

      5, 07.03.2011, 100


      does anybody have any idea? any help and feedback are appreciated

       

      Beck