Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Hi,
Check this link
wiki.qvsource.com/Disabling-Standard-Mode-In-Qlik-Sense.ashx
Hope this helps you.
Regards,
Jagan.
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?
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
Or check standard mode and define a folder connection to c:\logfiles.
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!