I am uploading 24 excel files. Each file has 4 or 5 columns and 540 rows. Each file is approximately 45 KB size. The computer has 8GB RAM memory. Each file has common column names so they are all linked to one another. I uploaded each file by clicking on the "Edit Script" icon -> click "Table Files" button", and Reloading files individually. After the 5th is loaded, QlikView takes 45 minutes to one hours to upload the 6th file. It displays a message "Executing Script". There are no calculation or expression in the script. The applications hangs up while uploading the 6th file. I tried clicking on "End" button and "Abort". No response. Do we need to free up any memory space? Do I need to type any special function or command in the script between individual file uploads. I do not believe QlikView will take so much time to upload small files. Can someone suggest or guide in what I am doing? I appreciate. Thanks
It sounds like you could have some kind of loop in your data model. I would suggest instead of just reloading, try clicking on the debug button (from the edit script screen) and tick limited load. Then you can restrict the amount of rows to a small number. Hopeful the result will allow you to complete a load and look at the table view.
May it be possibble that you read every file in a seperate load command and if yes, do you use the QUALIFY command? If not QlikView will automaticly create synthetic kes to get the "connection" between the different tables. And the more tables you have the more synthetic keys will be generated between all the loaded tables. You can use QUALIFY to set a prefix for each load. Or you can use a CONCATENATE to have all the results in one table (for that you can use a additional filed to know the source; for example: "LOAD ...., FileName() as SourceFile FROM <file>".
Try to create a QVD of the excel file in before stage and use that QVDs in the place of direct use of excel and make the model. Also there may be synthetic tables is created or may be circular loop so before making perfect data model remove the synthetic keys and the circular loops and then use the application. To check your load yes load limited rows and check the circular loop and data models.