I am doing an incremental load where basically I am saving the newest data in a qvd and load the old data from another qvd. Then I just merge both qvds and remove any duplicate ones by looking at their IDs.
I am merging the qvds by doing this:
LET q_Books= 'BooksOld.qvd';
FROM BooksNew.qvd (qvd);
FRom BooksOld.qvd (qvd)
STORE Books INTO '$(q_Books)';
Everything works good and the qvd is updated with the new data but as soon as the script finishes the 'script execution process' gets stuck and I have to force close the qvw.
Then I separated the storage of the new data in one qvw and the merging of the data in another qvw and everything worked fine and the 'script execution process' closed normally.
I really need both processes to be in the same qvw, does anyone know how to go about it please?
Thanks for you reply. Yes the user has the required acces to the directory.
Also, I have tried the Resident load, infact that was the approach I was working with at first, then I stored them in separate qvd for testing. The same happens when using 'Resident'; the 'script execution process' gets stuck and I have to force close qlikview.
The thing is that if I do them in separate qvws, everything works fine and also the qvds are updated succesfully.
if you have two or more tables with a lot of same field names qlikview will try to calculate the syntetic keys. Depending on the data volume this can take very long or even never end. Solution: Make sure each Table has only one key field to every other table.