Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

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

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
stevedark
Luminary Alumni
Luminary Alumni

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
Author

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

stevedark
Luminary Alumni
Luminary Alumni

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

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