2 Replies Latest reply: Mar 21, 2013 9:44 AM by arnes beganovic RSS

    Extend table during load based on dates



      I have table like this:


      PartNumber, Date, Price

      A,2013-03-21, 1EUR

      A,2013-03-25, 2EUR


      Can I extend table during load in order to add rows like this:


      A, 2013-03-21, 1 EUR

      A, 2013-03-22, 1 EUR

      A, 2013-03-23, 1 EUR

      A, 2013-03-24, 1 EUR

      A, 2013-03-25, 2 EUR

      A, 2013-03-26, 2 EUR


      etc (when new price, take it and continue to add same price until there is new)


      I have cca 5000 parts and period od one month which means cca 150.000 rows at the end.