using loop to generate multiple qvds

[Anonymous]

Hi..

I am using a loop to generate multiple qvd.

below is my script

SET DATA_FilePath='C:\Users\43862460\Desktop\Incremental Load\';

FILES:
load * Inline [
FileName
Echannels
MEHIE
];



for i  = 1 to FieldValueCount('FileName')

let lastexectime  =  num(date(ReloadTime(),'MM/DD/YYYY hh:mm:ss TT'));
let BeginningThisExectime  =  num(date(now(),'MM/DD/YYYY hh:mm:ss TT'));

let vFileName  =  FieldValue('FileName',$(i));

$(vFileName):
load
*

FROM
[$(DATA_FilePath)$(vFileName).xlsx]
(ooxml, embedded labels) where ([Modified Date] >= '$(lastexectime)' and [Modified Date] < '$(BeginningThisExectime)' ) ;
STORE $(vFileName) into [$(DATA_FilePath)$(vFileName).qvd](qvd);


next i;

drop Table FILES;

This script run fine when there is a single File name and generate qvd.

The moment I add a second file name to it it says unable to store the second qvd in the given path. The first qvd gets created successfully.

Can anybody please help as to what is going wrong with QVD creation for the second file?

[Anil_Babu_Samineni · Accepted solution]

May be helpful

https://community.qlik.com/docs/DOC-6754

Or

Below link, Check from 3 rd statement of Loop

Loading Multiple QVD files