How to load qvds from last 8 months from specific days and concatenate each other

[qliklearnervir]

I have a Qvds from July 2019 to Feb 2020 till today.

I have to load the last 8 month data but just have to pick 1 qvd from each month and date should 5th of every month.

My Qvd structure are like Data_XXXXXXXX.qvd 

i am not able to build the loading structure please help me find out the solution.

Data_20190701.qvd

Data_20190702.qvd
.
.
.
.
.
.
.
.
.
.
.
Data_20200201.qvd

Data_20200202.qvd

Data_20200203.qvd

Data_20200204.qvd

Data_20200205.qvd

please suggest.

[Vegar]

I and @petter did give you two suggested solutions to a quite similar question a couple of weeks ago. 

https://community.qlik.com/t5/QlikView-Scripting/how-to-load-specific-qvds-from-last-6-month-data-ne...

I think those approaches could be useful in this case as well 😃 What do you think @qliklearnervir ?

[qliklearnervir]

I have issue with to use include file .

Is there any other way to load data like that.

[Vegar]

Go for Petters solution or examine the content of the include file and create something similar in your environment. 

[Brett_Bleess]

The Include file is nothing more than a file with script code, if you do not want to do the Include, copy/paste the file contents into your script...

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Syste...

Regards,
Brett

[martinpohl]

a simple script:

Data:

load * inline [

Samplefield

];

for vMonths = 0 to 7  // how many months you want to load back

let vFilename=date(addmonths(today(),-$(vMonths),'DDDDMM');

concatenate (Data)

load

*

from Data_$(vFilename)*.qvd (qvd);

next

Regards