loading file from local qvd

[alec1982]

hi all,

When trying to load data from a local qvd I am not able to type

TabeA:

Load * from c:\\logfiles\filename.qvd;

I get error...

the only way i could do it is by going through the "Add Data" button and then navigate to the qvd. but the problem is tat adds my name into the load as follow:

table1:

load *

from [lib://logfiles (na\alec.harf)/filename.qvd;

do you know how can i get the top solution to work as i dont want my name to be assigned to it.

if you explain why my name shows on it then it will be wonderful too..

Thank you in advance!

Alec

[#2 · Accepted solution]

Alec,

In Qlik Sense the concept of data loading is changed relative to QlikView.  In Qlik Sense "Standard" mode, you create data connections that point to folders, databases, or web locations.  From there you add files to the load script with the LIB command referencing the data connection and the filename.

The reason why your name pops up is that you created the data connection.  Qlik Sense uniquely names the data connection by appending the userdirectory\username  to the end of the data connection reference.

It is possible to switch Qlik Sense into "Legacy" mode to enable absolute path references.  Read more about that here: http://help.qlik.com/sense/2.0/en-US/online/#../Subsystems/Hub/Content/LoadData/file-system-access-r...

Here is where you can learn how to disable Standard mode: http://help.qlik.com/sense/2.0/en-US/online/#../Subsystems/Hub/Content/LoadData/disable-standard-mod...

Please mark response as helpful or answered to assist other community members with a similar question.

[jagan]

Hi,

Check this link

wiki.qvsource.com/Disabling-Standard-Mode-In-Qlik-Sense.ashx

Hope this helps you.

Regards,

Jagan.

[alec1982]

thank you all for the information. I am working on the server side. I logged in and opened the engine setting and found the standard mode already unchecked... so do I need to check it in order to get the path to work?

[jonathandienst]

Is this a type? You have a double backslash in the path.

Load * from c:\\logfiles\filename.qvd;

should be

Load * from c:\logfiles\filename.qvd;

Leave standard mode unchecked

[jonathandienst]

Or check standard mode and define a folder connection to c:\logfiles.

[alec1982]

thank you all.. as default the standard box was unchecked and I was getting the error. I have checked it, run the engine service, unchecked and run the service again to get it to work.

Thank you for all your help!