Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $400 before Dec 31st: REGISTER 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

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

Check the Data Model Viewer and check.

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

3 Replies
kaushiknsolanki

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

Check the Data Model Viewer and check.

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
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!