Discussion Board for collaboration on QlikView Scripting.
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
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
View solution in original post