7 Replies Latest reply: May 28, 2015 6:15 AM by Sunny Talwar RSS

    Skript auto fill up missing lines

    Robert Reitschuster

      Dear all,

      I have to create a table with the price for each day.
      The basic table has stored only the price by item by date.

       

      Following data existing:       

       

      ItemDatePrice
      101.01.20153
      101.02.20152.5
      101.03.20152.7
      201.01.20152.7
      201.02.20152.2
      201.03.20152.4
      301.01.20152.4
      301.02.20151.9
      301.03.20152.1

       

      Result looks like

       

       

      ItemDatePrice
      101.01.20153
      102.01.20153
      103.01.20153
      104.01.20153
      105.01.20153
      1….3
      130.01.20153
      101.02.20152.5
      102.02.20152.5
      102.03.20152.5

       

       

      Any ideas to have a well performing soloution?