topic web data source in QlikView

web data source

Thu, 31 Mar 2016 07:31:08 GMT

Hi,

Everyone!

I want to get some information about the key words "President" and "American" from google serach engine. So I will use the import data guide.But I have no "URL".Could anyone help me? How could I use the guide if I have no internet file but want to get the information ?

What kind of internet file can write into this place?

Re: web data source

jonas_rezende — Thu, 31 Mar 2016 12:15:24 GMT

Hi, daniel xie.

What result wish getting? Please, exemplifies what you want that to achieve.

Regards,

Jonas Melo.

Re: web data source

Fri, 01 Apr 2016 03:47:50 GMT

American President Year Name like above table

Re: web data source

settu_periasamy — Fri, 01 Apr 2016 04:39:35 GMT

You should give the URL. for e.g

LOAD @1,
@2,
@3,
@4,
@5,
@6,
@7,
@8,
@9,
@10,
@11
FROM
[https://en.wikipedia.org/wiki/List_of_Presidents_of_the_United_States]
(html, codepage is 1252, no labels, table is @1);

Edit:

Re: web data source

Kushal_Chawda — Fri, 01 Apr 2016 05:34:11 GMT

Copy the appropriate URL in internet file box then click finish and reload the application.

Which URL you are using?

Re: web data source

Tue, 05 Apr 2016 02:40:27 GMT

but if I donot have the URL of the file ,how could I get the information from the website"https://en.wikipedia.org" ?