Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
From Script Perspective everything looks fine, but what i sense is anyone file will have different field.
Check the Data Model Viewer and check.
From Script Perspective everything looks fine, but what i sense is anyone file will have different field.
Check the Data Model Viewer and check.
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.
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!