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

[#1]

Dear everyone,

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

I have script as below

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!

[Anonymous]

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.

[#3]

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]

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]

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]

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

[#7]

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.

[#8]

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]

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]

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.