Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
See here for how to do that.
Thanks,
this helped a lot