topic Re: Web file - error : Couldn't resolve host name in Connectivity & Data Prep

Web file - error : Couldn't resolve host name

Fri, 02 Apr 2021 08:05:50 GMT

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

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

stevedark — Tue, 12 Sep 2017 08:33:41 GMT

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

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

Thu, 21 Sep 2017 11:12:56 GMT

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 ..

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

stevedark — Thu, 21 Sep 2017 13:20:00 GMT

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

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

evan_kurowski — Mon, 11 Dec 2017 20:17:13 GMT

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 .