2 Replies Latest reply: Apr 25, 2017 4:23 PM by Tomasz Truszkowski RSS

    Script Error

    Milly Ogina

      The following error occurred:

       

      This statement only works with lib:// paths in this script mode

       

      The error occurred here:

       

      Data: LOAD * FROM [C:\Users\olginam\Desktop\Data\*.qvd] (qvd)

       

      Data has not been loaded. Please correct the error and try loading again.

       

       

      Note: Title edited by community moderator for brevity.

        • Re: Script Error
          Jaime Aguilar

          Hi,

          this is happening because in this case syntaxis is slightly different in QlikView and Qlik Sense.

           

          In QlikView you can load data with the following syntax LOAD * FROM [C:\Users\olginam\Desktop\Data\*.qvd] (qvd)

           

          However, this will not work in Qlik Sense, because Sense introduces the concept of libraries. In Sense every data source is a connection. In data load editor, in the right part you will find your connections (it can be pretty much anything: a folder, an oledb/odbc connection, etc). Here you create a new connection, selecting folder as type and then you just have to find the needed folder within your files.

           

          So basically the difference between QlikView and Qlik Sense is that in View you make reference either to the full path or to a relative path without having to configure a connection. In sense you have to create the connection to the folder and when you load data you make reference to the connection name (with the lib: part) instead of the file path, so it would be like this:

           

          LOAD * FROM [lib:\\YourFolderConnection\*.qvd] (qvd)


          hope this helps,


          kind regards

          • Re: Script Error
            Tomasz Truszkowski

            Create new data connection and link it to the folder instead of using absolute path.