this is the format try this
Table name :
FROM "table name in SQL "(exactly the same);
store Table name into [QVD NAME.qvd ](qvd);
drop table TABLE NAME ;
just replace your table name here and make sure you have connection to odbc .
save you qvd near your qlik view or qlik sense document
when you write the script in qlik view or qlik sense
table name :
[QVD NAME .qvd ](qvd);
I even suggest you, create all your documents in qlik view and just create a binary link in qlik sense , which is easy.
can u see at the bottom i mentioned some thing ..
First of all create the doc in qlik view and do a binary load which is simple
Script for Binary load
Binary [lib://Name of the connection /NAME of the document];
Name of the connection :
It should be a folder < go to data load editor< create new connections<Folders < Folder path(path of qvw) eg :H/documets/qvw<at the bottom of connection name it(use this one in binary name of connection)<click create<name of the qvw< add all the additional files and supporting documents in the next sections < Load data
this will work