Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be helpful
https://community.qlik.com/docs/DOC-6754
Or
Below link, Check from 3 rd statement of Loop
May be helpful
https://community.qlik.com/docs/DOC-6754
Or
Below link, Check from 3 rd statement of Loop