Processing of 1000 xml-files in a loop: QlikView hangs
I have to make a report for vehicle orders. In every single xml-file there is one order for one vehicle.
The xml-files have to be processed in a loop and they all have the same structure and fields.
I have tested my coding with 3 xml-files and I get a correct result. However, the folder contains 1000 xml-files which have to be handled. After more than 100 files I get no response from QlikView, it seems that QlikView hangs or crashes.
The coding includes 3 load statements for the tables included in the xml-file which are linked by a join in my coding.
I have attached the coding, the table structure (reading 3 xml-files) and the result.
Is the coding incorrect or is it not possible to handle such a big number of xml-files?