3 Replies Latest reply: Sep 22, 2014 9:44 AM by Sathish G RSS

    How to copy previous day data?

    Gabriele Boccassini

      Hi, I have a big table (36 million rows) like this (the real table has 4 different price columns):

       

      PlaceCategoryDate(dd/mm/yyyy)Price
      A101/01/201410
      A102/01/2014
      A103/01/20148
      ............
      A201/01/20145
      A202/01/2014
      A203/01/2014
      B.......

       

       

      I want that the places without price (for a category) have the last price:. For example

      PlaceCategoryDate(dd/mm/yyyy)Price
      A101/01/201410
      A102/01/201410
      A103/01/20148
      ............
      A201/01/20145
      A202/01/20145
      A203/01/20145
      B.........

       

      Now I use the peek function for copy the last price, but the the reload is more slow.

      Is there a faster way?

      Thanks