Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

alec1982
Valued Contributor II

loading file from local qvd

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

1 Solution

Accepted Solutions
Not applicable

Re: loading file from local qvd

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.

6 Replies
Not applicable

Re: loading file from local qvd

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.

MVP
MVP

Re: loading file from local qvd

Hi,

Check this link

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

Hope this helps you.

Regards,

Jagan.

alec1982
Valued Contributor II

Re: loading file from local qvd

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?

MVP
MVP

Re: loading file from local qvd

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

MVP
MVP

Re: loading file from local qvd

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

alec1982
Valued Contributor II

Re: loading file from local qvd

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!

Community Browser