Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Rayan2019
Partner
Partner

How to load QVD in loop sequencially starting from particular year & month

I have multiple QVD stored in shared location having naming as "lib:location_2018_001.qvd" format.

Data is available from 2016 and for all months.

 But My requirement is to load all qvds from 2018 onwards all months  till current year  & month

Can some expert help me out please?

1 Solution

Accepted Solutions
Gysbert_Wassenaar

What are the names of the files you want to load the data from?


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
shiveshsingh
Master
Master

Try this during reload,

 

Load * from QVDs where

mid(QVDs, 10,4)>=2018

Gysbert_Wassenaar

What are the names of the files you want to load the data from?


talk is cheap, supply exceeds demand

View solution in original post

Rayan2019
Partner
Partner
Author

The files are having same kind of naming convention.just as

Lib://shared folder/sapbw_csmp_actual_2018_001.qvd

Lib://shared folder/sapbw_csmp_actual_2018_002.qvd

.

.

.

Lib//shared folder/sapbw_csmp_actual_2018_012.qvd

.

.

So on

Rayan2019
Partner
Partner
Author

@siveshsingh

This will not work.

I have mentioned the file names too.

Gysbert_Wassenaar

The easy way out is to use wildcard loads for each year:

Data:
LOAD * FROM [Lib//shared folder/sapbw_csmp_actual_2018_*.qvd] (qvw);
Concatenate (Data)
LOAD * FROM [Lib//shared folder/sapbw_csmp_actual_2019_*.qvd] (qvw);

The disadvantage is that each year you need to add two lines for the new year.

talk is cheap, supply exceeds demand