Loading files one at a time

davyqliks — Sat, 16 Nov 2024 00:11:00 GMT

Hi All,

I have a script where files need to be loaded one at a time. the daily file which imports compares to the data in the qvd and overwrites with the latest where the invoice no exists.

On a daily basis this is fine and working well with the file being moved to a done folder after the load.

I have an issue and all files need to be reloaded. i am looking at 15seconds per load for 8 months of files for 11 qv projects, one per site

Does anyone know of a scripting method that will load one file, save and then load the next file to save me hours of manual loading?

Thank you in advance

Daniel

Re: Loading files one at a time

rubenmarin — Fri, 07 Aug 2020 16:55:33 GMT

Hi, Why you need to save the document each time?

I would try to create a bucle that does the needed logic for each file in a bucle, using DROP Table and STORE where necesary to simulate the needed logic

for each File in filelist ('Path\*.*') ...// do stuff next

topic Loading files one at a time in QlikView

Loading files one at a time

Re: Loading files one at a time