7 Replies Latest reply: Jun 19, 2018 2:47 AM by Rangam Seshadri RSS

    Storing a table as a QVD file

    Andy Manuja

      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 D: 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 D: 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