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

[Rayan2019]

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?

[Rayan2019]

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?

[shiveshsingh]

Try this during reload,

Load * from QVDs where

mid(QVDs, 10,4)>=2018

[Gysbert_Wassenaar · Accepted solution]

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

[Rayan2019]

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]

@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.