Storing a table as a QVD file

[andymanu]

Hi,

I have loaded data into Qlik Sense using an excel file. The temporary name of the table is "Products"

Please refer the attached script.

Products:

LOAD

    Prod_ID,

    Prod_Name,

    "Date",

    Quantity,

    "Selling Price",

    Country1,

    Country2

FROM [lib://Product/Product Data.xlsx]

(ooxml, embedded labels, table is Sales);

The name of the excel sheet document is "Product Data" and the excel sheet name is "Sales" (which also can be seen from the "FROM" statement above).

The said excel document is saved in D:\Data folder.

I want to store the table as a qvd file in to a folder name Data inside the 😧 drive,

Thus, the path is "D;\Data"

I used the below script but it is popping up an error message stating, " connection not found D:"

STORE Products into [lib://D:\Data]Product Data].qvd;

I tried removing the 😧 as well but still unable to execute the script properly.

Appreciate a lot if you could help me to resolve this storing as a qvd file issue.

Thanks.

Regards,

Andy

[charlie_firemind]

Hey,

Reuse the existing connection if storing in the same directory.

STORE Products into [lib://Product/Product Data.qvd];

[petter]

Just as you or someone already created a connection called Products that is used in the load statement after the lib:// you will have to create a connection to the folder D:\Data and name it Data and then you can do someting like this:

STORE Products INTO [lib://Data/Product data.QVD] (qvd);

[andymanu]

Hi Petter,

Thanks for your reply. However, still I am getting an connection error.

, stating,

"Connection not found: Data"

I tried setting the Data folder permissions to "Modify" for everyone.

Thanking you in advance if you could help me to resolve the issue.

Thanks.

Andy

[andymanu]

Hi Petter,

Out of no where, I tried the below statement to store data and it worked,

"STORE Products INTO [lib://Product/Product Data.QVD] (qvd);"

It seems like a similar path to the fetching data has to be used despite the folder name where the original excel file was located.

Does it means that, when fetching the data from a particular location, Qlik Sense creates a path automatically and we have to use the same path to store the data?

However, thanks for your help and appreciate of you could clarify the above said suggestion.

Regards.

Andy

[arvind1494]

Hi Andy,

first create new connection :

choose folder D://Data and give name to the connection as QvdStore

Now in your script do something like this

store Products into [lib://QvdStore/Products.qvd](qvd);

[andymanu]

Hi Petter,

Thank you so much for your feedback.

It helped me to understand the concept around the data connection.

Regards,

Andy

[rangam_s]

STORE Products into [lib://Product/Product Data.qvd](qvd);

try this