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?
Solved! Go to Solution.
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.
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:
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.