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

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

Wed, 25 Nov 2020 16:16:04 GMT

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!

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

Anonymous — Thu, 23 Mar 2017 10:34:23 GMT

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.

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

Thu, 23 Mar 2017 10:43:10 GMT

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,

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

rahulpawarb — Thu, 23 Mar 2017 10:52:47 GMT

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

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

Frank_Hartmann — Thu, 23 Mar 2017 11:00:19 GMT

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

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

bhupesh_gupta — Thu, 23 Mar 2017 11:02:29 GMT

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

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

Fri, 24 Mar 2017 13:09:58 GMT

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.

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

Fri, 24 Mar 2017 13:11:28 GMT

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,

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

Frank_Hartmann — Fri, 24 Mar 2017 14:17:17 GMT

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:

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

swuehl — Fri, 24 Mar 2017 14:26:26 GMT

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.

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

Fri, 24 Mar 2017 15:05:02 GMT

Thank you very much for the kind reply.

I understand better now