Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Extend table during load based on dates

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.

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Not applicable

Re: Extend table during load based on dates

See here for how to do that.


talk is cheap, supply exceeds demand
2 Replies
Gysbert_Wassenaar
Not applicable

Re: Extend table during load based on dates

See here for how to do that.


talk is cheap, supply exceeds demand
Not applicable

Re: Extend table during load based on dates

Thanks,

this helped a lot