Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Giel0
Contributor
Contributor

Drop table after load and store multiple files from folder

Hi,

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;

What is going wrong here?

Labels (2)
1 Solution

Accepted Solutions
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

From Script Perspective everything looks fine, but what i sense is anyone file will have different field.

Check the Data Model Viewer and check.

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

3 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

From Script Perspective everything looks fine, but what i sense is anyone file will have different field.

Check the Data Model Viewer and check.

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
abhijith28
Creator II
Creator II

There's no issue with the script, may be check other tabs or main sheet where it includes load script or binary load happening in the app.

 

Giel0
Contributor
Contributor
Author

Finally found it, two of the files had an extra column which I did not noticed.
Did not know that this prevents the script  from dropping the table. 

Thanks a lot for your help!