Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hey,
Reuse the existing connection if storing in the same directory.
STORE Products into [lib://Product/Product Data.qvd];
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);
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
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
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);
Hi Petter,
Thank you so much for your feedback.
It helped me to understand the concept around the data connection.
Regards,
Andy
STORE Products into [lib://Product/Product Data.qvd](qvd);
try this