Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

issue while creating multiple qvds using incremental load

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 vFileNamefieldvalue('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;

0 Replies