Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Fetching data from source which is not in my computer. [Relative path?]

Dear everyone,

I am very very new at Qlikview, so I really have only basic knowledge.

I have script as below

Capture111.PNG

Problem is, the active projects file andmeta employees file are not saved in my computer. There should be some ways to fetch those files which are not saved in my hardware I guess? Could you guys explain how to do it? and show me syntax in detail in my case? I think ODBC would be easily linked with my computer so it would not be a problem.. Thank you in advance.

Regards!

10 Replies
laddu_927
Specialist
Specialist

Hi Hojun. Welcome to Qlik.

Where are the files?? In a remote machine?? If you can access that remote machine files from your machine then you can pull them into qlikview. Just give the path like \\<servername>\<path>\Active_Projects.xlsx.

Hope it helps.

Not applicable
Author

Hello Shiva,

Active projects and Meta employees files are saved in a differente person`s computer. But I want to use it without saving the files in my computer. Is it the case that I should do as you asked me to do? Because it is not a server, just a different computer, I think it is not what you thought it would be. Can you provide more info?

Regards,

rahulpawarb
Specialist III
Specialist III

Hello Hojun,

Trust that you are doing good!

Please refer sample script given below (you can modify it, if needed):

LOAD [Responsible],

      Category,

   [Project ID] as projectId,

   Name,

   [L2 MD Offered],

   [L3 MD Offered],

   [L3 MD Total Offered]

FROM  [\\MySharedServer\OWNCLOUD_1.1\cfde-reporting\02_META\Active_Projects.xlsx]

(ooxml, embedded labels, table is Table);

Regards!

Rahul

Frank_Hartmann
Master II
Master II

you will need to mount the external harddisk to your computer.

(right click on Computer Symbol and then connect networkdrive)

therefor you will need the local ip of the other computer and the credentials to log into the windows account!

Once you have done that you can use the path as described below!

hope this helps

bhupesh_gupta
Creator
Creator

Hi Hojun

Kindly save the data files on a shared folder which can be access from your machine.

You can create a map drive and then fetch the data from the shared path.

PS: Don't forget to get access to that shared folder for yourself .

Hope this helps

Regards

Bhupesh

Not applicable
Author

Dear Hartmann,

So I need to connect network with the other computer that has the files? which means I can never just do it without connecting? Can I do like a magic where I can simply fetch files that are in other computer to my computer without connecting or saving files to my computer?

Thank you in advance,

Regards.

Not applicable
Author

Thank you Rahul.

I have tried this, but it doesnt work. As Hartmann mentioned above, I have to do some pre-work before putting those. Can you show me step by step the pre-work as well?

Regards,

Frank_Hartmann
Master II
Master II

Yes you will need to connect because of the credentials/Login. Otherwise you will get no access to the files on that computer. But the owner of the other PC could also create a shared networkfolder. Then the Files should be available in your local network and you will not have to make a connection.

do you see the computername of the other pc here:

swuehl
MVP
MVP

So I need to connect network with the other computer that has the files? which means I can never just do it without connecting? Can I do like a magic where I can simply fetch files that are in other computer to my computer without connecting or saving files to my computer?

Yes, you can -- if you are the NSA or an evil hacker 😉

But seriously, if you need to share files with the other user, you should consider storing the files on a shared storage (could be the other user's computer with a shared folder, but what if she switches off her computer?). Access rights could be set that only the other user can modify the data, you are only allowed to read the data.

Ask your local administrator, I am sure this is kind of common requirement in your company and a policy exists.