Qlik Community

Qlik Sense App Development

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

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

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

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
Highlighted
Master
Master

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

Try this during reload,

 

Load * from QVDs where

mid(QVDs, 10,4)>=2018

Highlighted
MVP & Luminary
MVP & Luminary

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

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

Highlighted
Partner
Partner

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

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

Highlighted
Partner
Partner

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

@siveshsingh

This will not work.

I have mentioned the file names too.

Highlighted
MVP & Luminary
MVP & Luminary

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

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