topic Multiple qvds creation in QlikView

Multiple qvds creation

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

i have one folder like (folder name) "SOURCE" in this folder having 5 Excel sheets like

Data 2016_4_25.xlsx

Data 2016_4_24.xlsx

Data 2016_4_23.xlsx

Data 2016_4_22.xlsx

Data 2016_4_21.xlsx

i will load all files at a time by using *

here my requirement is how can i create 5 qvd's.(separate qvd for each sheet) .

swuehl — Tue, 26 Apr 2016 16:51:25 GMT

If your final goal is to produce the qvds, I would use FOR EACH .. IN FILELIST (..)

to iterate over your excel files, load one after the other and store to QVD right away.

qlikview979 — Tue, 26 Apr 2016 17:01:11 GMT

Hi Swuehl,

please share with "FOR EACH".

swuehl — Tue, 26 Apr 2016 17:07:42 GMT

Something along these lines

FOR EACH vFile IN FILELIST('.\Data 2016_4_*.xlsx')

TEMP:

LOAD Field1,

Field2,

...

FROM [$(vFile)]

(...);

STORE TEMP INTO [$(vFile).qvd] (qvd);

DROP TABLE TEMP;

NEXT vFile

trdandamudi — Tue, 26 Apr 2016 17:38:47 GMT

Here is the sample:

qlikview979 — Tue, 03 May 2016 04:56:44 GMT

Hi Swuehl,

Thanks for your response

Regards,

Mahesh