Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how i can load data from windows network shared folder in qlikview

Hi Guys,

i had my data in  network shared folder  in that folder all my  data in 6 different  excel files.

so  how  should  i connect to  particular network shared folder path.

(in my local machine  thru  table files am able to connect &  reload . but  same thing in QA  its failing. in QA its not picking the data from particular folder, so not refreshing the data)

please help me

7 Replies
Not applicable
Author

It sounds like the User running the service on QA maybe have no access to this shared folder.

Not applicable
Author

Are you having issues with the syntax in the load script? If so, you would use a UNC path in the FROM statement (i.e. \\server\share\file). Also you may want to uncheck the "Relative Path" option.

qv.png

sudeepkm
Specialist III
Specialist III

As advised You need to check if the QA Publisher service account ID has access to the Network drive.

It is better to use relative path instead of full path.

When you use relative path then you do not have to worry about the root.for example while using relative path your from clause will be like this:

From [..\DataSources\abc.xlsx]

you do not have to use the root name here and it will work as long as you have the application folder structure same across all environments.

Not applicable
Author

Hi

1)  i used  same way which u mentioned  below is my from stmnt:

FROM

[\\colo-lonfrcel01\HR-QlikviewData\Mapping - Location.xlsx]

2) i already unchecked relative path.

but not working.

Not applicable
Author

Are you running QlikView from your desktop and trying to load files from the network share?

Not applicable
Author

when am running from my desktop  am able to load the data from network share folder properly.

in my desktop   thru table files  i have loaded manually   for each time mentioning the network shared folder.

But  same file in QA environment not reloading.

Not applicable
Author

So I think as Daniel and Sudeep mentioned, its possible that the account that you are using in QA environment might not have the appropriate permissions to the share.