topic Re: import data from HTML file in QlikView

import data from HTML file

Fri, 03 Apr 2015 09:03:10 GMT

Hi Team,

I want to import data from a website say for example-http://updateox.com/india/state-wise-population-of-india-as-per-2011-census/

while reloading the QVW file, I am getting error Field not found, but when i recheck it the field name is already present on the website.

I have attached my load script screenshot and error msg screenshot.

Please help me out with a solution.

Regards

Priyanka

Re: import data from HTML file

prieper — Fri, 03 Apr 2015 18:13:22 GMT

Seems if if there is a hidden row with the totals in this table ...

You may validate by executing LOAD * FROM .....

You may use a script like:

Data:

LOAD

@1 AS [State /UT Code],

@2 AS [India/State/ Union Territory #],

@3 AS Population,

@4 AS Males,

@5 AS Females,

@6 AS Percent

FROM

[http://updateox.com/india/state-wise-population-of-india-as-per-2011-census/]

(html, codepage is 1252, no labels, table is @1)

WHERE RECNO() > 2;

HTH Peter

Re: import data from HTML file

Anonymous — Fri, 03 Apr 2015 19:36:00 GMT

Save the html page into your Desktop and try from there...

Re: import data from HTML file

ramoncova06 — Fri, 03 Apr 2015 19:59:38 GMT

switch the load to *

LOAD *

FROM

[http://updateox.com/india/state-wise-population-of-india-as-per-2011-census/]

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

Re: import data from HTML file

petter — Fri, 03 Apr 2015 20:15:05 GMT

Try this instead:

LOAD

@1 AS [State /UT Code],

@2 AS [India/State Union Territory #],

@3 AS Population,

@4 AS Males,

@5 AS Females,

@6 AS Percent

FROM

[http..........]

(html, utf8, no labels, table is @1);

Obviously QlikView isn't very fond of / in a column-name ... a bug maybe ...

Even this works well too:

LOAD

FROM

[http..........]

(html, utf8, embedded labels, table is @1);

Re: import data from HTML file

petter — Fri, 03 Apr 2015 20:28:18 GMT

I did a quick test and it is actually a kind of bug... In HTML two or more consequtive spaces are really just one space. I noticed that the two fields [State /UT Code] and [India/State Union Territory #] har two consequtive spaces before respectively /UT and Union....

Just removing a single space in both of them let me load without error:

LOAD [State /UT Code],

[India/State/ Union Territory #],

Population,

Males,

Females,

Percent

FROM

[...//updateox.com/india/state-wise-population-of-india-as-per-2011-census/]

(html, utf8, embedded labels, table is @1);

Re: import data from HTML file

Anonymous — Sat, 04 Apr 2015 04:00:59 GMT

Hi Priya,

the webfile wizard is generating an extra space between state and /UT Code

as per your query it is like this

[State /UT Code],

and i tried this [State /UT Code] . it did worked

see the attached Qvw file

Re: import data from HTML file

Thu, 16 Apr 2015 06:38:17 GMT

Agreed with Petter Skjolden. This one I tested and works fine. Attached is the QVW.