Drop table after load and store multiple files from folder
I am loading multiple .xlsx files with same columns from a folder and want to store them all into a QVD and subsequently drop the table. In order to load the QVD later on in the script. Despite the use of the 'Drop table' it doesn't work. The data is still being loaded.
Below the script:
Ratings: LOAD * FROM [lib://DATA_SHARE/inkoop/Qlik data/Ratings/*.xlsx] (ooxml, embedded labels, table is [Sheet 1]);
Store Ratings into [lib://QVDFolder/Data/Ratings_accessoiries.qvd] (QVD); Drop table Ratings;