Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Loading files one at a time

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

 

Labels (3)
1 Solution

Accepted Solutions
Highlighted

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

 

View solution in original post

1 Reply
Highlighted

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

 

View solution in original post