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

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

Rayan2019 — Sat, 16 Nov 2024 20:11:45 GMT

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?

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

shiveshsingh — Tue, 27 Aug 2019 09:36:06 GMT

Try this during reload,

Load * from QVDs where

mid(QVDs, 10,4)>=2018

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

Gysbert_Wassenaar — Tue, 27 Aug 2019 10:15:14 GMT

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

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

Rayan2019 — Thu, 29 Aug 2019 19:24:20 GMT

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

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

Rayan2019 — Thu, 29 Aug 2019 19:27:31 GMT

@siveshsingh

This will not work.

I have mentioned the file names too.

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

Gysbert_Wassenaar — Fri, 30 Aug 2019 11:16:52 GMT

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.