I have a script that conducts a big analysis in several steps - the first step encompasses loading the original base_files in Excel and generating a nr. of qvd_files which are then loaded much, much faster.
The only potential problem is that the folder_structure has to be there - there have to be the paths like >> Basisdaten\2016\September << - one folder for the year and in that one folder per month.
Is there a possibility to create folders in QlikView? I can do it via the command_line, can't i? With MKDIR
Yep, that works 😉 And with the option >> -p << I can first check if the directory exists before overwriting it ...
your mentioned folder-structure might be logically for many people but they mustn't be very suitable to work with the data or to process the data with automatic routines. Therefore it could be an alternatively to pull all these data into a second parallel folder-structure with tools like robocopy (and maybe moving them by this from a network-storage to the hd/ssd-storage from the server).
In general you could do all this directly with qlikview by using appropriate EXECUTE statements to create folder/files and/or to copy/move/delete them within dirlist/filelist-loops but tools like robocopy are providing more features and performance. Of course it will need some efforts to get familar with these kind of tools and to built stable solutions but it could make things easier within qlikview and also speed up the data-loading.
