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;
