Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

See here for how to do that.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

See here for how to do that.


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks,

this helped a lot