Qlik Community

Qlik Connectors Discussions

Discussion Board for collaboration regarding Qlik Connectors.

Not applicable

Web file - error : Couldn't resolve host name

Hi Team,

Am new to the qlikview tool. While learning i found one difficulty that is, When i was trying to load a web file it throws error " Couldnt Resolve Hostname"

Kindly help me to solve this. as well as tell me useful resource or pdf for learning qlikview

4 Replies
MVP
MVP

Re: Web file - error : Couldn't resolve host name

Hi Kumar,

That sounds like the URL is not correct.  Have you tried copying and pasting it into a browser to ensure you get the results you expect?

Be aware that if you are doing a reload in QV Server the service account may have different firewall/proxy settings than your own user account.  Similarly, if you have connected to the server via RDP things could be different from when you are on your own machine.

Hope that helps.

Steve

Not applicable

Re: Web file - error : Couldn't resolve host name

Hi Steve,

Am using Qlikview personal edition. In that i want to load internet file / website file,

Could you help me with any examples,

Kindly help ..

MVP
MVP

Re: Web file - error : Couldn't resolve host name

Here are a couple of queries that should work for you if you copy and paste them into a load script:

LOAD Year,

     Tournament,

     Winner,

     [Runner-up]

FROM

[https://en.wikipedia.org/wiki/List_of_Grand_Slam_singles_finals]

(html, codepage is 1252, embedded labels, table is @3);

LOAD Date,

     Day,

     Holiday,

     Countries

FROM

[https://www.dropbox.com/s/xm6rjxpwdff2ed7/English%20Bank%20Holidays.xlsx?dl=1]

(ooxml, embedded labels, table is [Bank Holidays]);

The first is a table in the middle of a web page, the second is a spreadsheet that is on the internet.  In both cases if you paste what is in the square brackets into a browser you should get the data come back.  QlikView can then interpret that.

Steve

evan_kurowski
Valued Contributor

Re: Web file - error : Couldn't resolve host name

Will second this observation.

I have some sample scripts reading off of Wikipedia URL and they are throwing 'Cannot resolve hostname' error on Qv 12.  Same script works fine when launched in Qv 11.2 . 

~E

Community Browser