issue while creating multiple qvds using incremental load

Anonymous — Mon, 06 Mar 2017 05:46:49 GMT

I am generating multiple qvds during incremental load. Script throws an error while creating the second qvd stating unable to Store Echannels into Echannels qvd.

If I use a no concatenate before the load statement it generates 2 qvds but generates synthetic table between the 2 tables and takes longer time to load. I am not sure what is going wrong. The data fields in the both the files are exactly the same.

FILES:
load * Inline [
FileName
MEHIE
Echannels
];

for i = 1 to FieldValueCount('FileName');

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

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

$(vFileName):

load *

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

STORE $(vFileName) into $(vFileName).qvd(qvd);

next i;

topic issue while creating multiple qvds using incremental load in QlikView

issue while creating multiple qvds using incremental load