Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using QLIK Sense Desktop. My source data is on an iSeries which I access via an ODBC connection.
I'd like to STORE the data I've retrieved into a QVD file so that I can perform incremental data loads from the source data file.
When I try to STORE my QVD file using this statement
STORE ShipmentFile INTO SFFILE.QVD;
I get an error saying that "No qualified path for file SFFILE.QVD".
I attempted to set a path using "directory" only to run into additional errors stating that "Directory statement only works with lib:\\ paths".
I don't want to store the QVD file on my iSeries, I want to store it on my desktop (for now).
I don't know how to direct where my QVD file is stored, can someone help?
Hi,
you must setup a new folder connection and after you can use the next sentence:
STORE TableName into [lib://qvd/]TableName].qvd;
Where qvd is the name of the new folder connection.
Regards,
Gabriel
Try like this
STORE ShipmentFile INTO C:\SFFILE.QVD;
Vikas
Try this one
STORE ShipmentFile INTO D:\QVD Files\ShipmentFile.qvd(qvd);
Drive =D
Folder=QVD Files
You need to disable standard mode to save into directory paths absolute or relative
Qlik Sense Desktop
In order to enable the previous load script behaviour in Qlik Sense Desktop (which is also the standard in QlikView) you will need to follow the instructions from the help to disable the standard mode. The instructions are:
The available modes are:
Hi,
Try This Way
STORE ShipmentFile INTO [lib://QVDFolder/ShipmentFile.QVD] (qvd);
Hi,
Try this:STORE ShipmentFile INTO [lib://<Connection Name>/<File name>.qvd];
That is the way to do it in QlikView. In Qlik Sense you use a library to store your QVDs to.
So I would advise against that suggestion.
Hi Vikas,
This syntax would not work in QlikSense untill you enable the legacy mode.
ok Thanks Actually I am not much familiar with sense .
Vikas
There is no enabling Legacy mode setting, disabling the Standard mode will allow you to use legacy scripts.