2 Replies Latest reply: Nov 17, 2012 8:29 AM by Przemysław Wojda RSS

    Multinested previous()?

    Przemysław Wojda

      Hi All,

       

      I've got a dataset with 2 columns where some records miss value in the first column. In these very records where values are missed I want to assign last value in the first column as shown below. I guess prevoius() will not work here. Do you have an idea how to solve it?

       

      Regards,

      Przemek

       

       

      INPUT
      ---------
      Name, City 
      John, Berlin
      Mary, London
      , Paris
      , Amsterdam
      
      OUTPUT
      -------------
      Name, City
      John, Berlin
      Mary, London
      Mary, Paris
      Mary, Amsterdam