Discussion board where members can get started with Qlik Sense.
What's the correct syntax for storing qvd's?
The folder i've created on the right in Data Editor is called QVD_FOLDER the actual folder on the server is called QVD, what am i doing wrong in the store syntax.
LIB CONNECT TO 'XXX.HOST.NAME.com (user_e111)';
sql select *
STORE SEGMENTS INTO [lib://QVD_FOLDER/SEGMENT.qvd](qvd); // with folder created in Data Editor name QVD_FOLDER
STORE SEGMENTS INTO [lib://QVD/SEGMENT.qvd](qvd); // with server folder name QVD
seems correct. you can try putting the connection string in ''.
i.e. 'lib://QVD_FOLDER/SEGMENT.qvd' (qvd)
Where will the connection string go?
do you want to store connection string as well in QVD ??
No just the table/data.
then try what Guohao suggested...
Is it not working?
Try putting the connection string - you mean the connection string for the QVD_FOLDER? where do i put the connection string?
The second one's right. You need to give the name of the connection you created.
Is this you are asking?
in the script..
Connection string on the top..............like connect to(Connection String Paramneter after connection)
Step2) Fetch the table
load * from Databasename.Tablename;
Step 3) create a QVD
store Tres INTO [lib://QVD_FOLDER/SEGMENT.qvd](qvd);
Step4) Drop the table
drop table Tres;
Step 1 - Connection string for the server or connection string for the folder