Reading information from a website. (How to include non table information??)

marcel_olmo — Mon, 24 Jan 2011 12:03:01 GMT

Hey guys, I was just testing how can Qlikview help, feeding us with Internet information via websites.

I've found a powerful website that give us description about websites called quarkbase.com

If you try to load the website, you only cand "add" the table info. (The information that is inside table tags <TABLE> <TH>....)

WebInfo:

LOAD F1,
Rank
FROM
[http://www.quarkbase.com/google.com]
(html, codepage is 1252, embedded labels, table is @2);

If you see the webpage : http://www.quarkbase.com/google.com, you'll notice you are missing a lot of useful information (pageranks, traffic ranks, alexa ranks, related tags,competitors, etc... ).

Is there any way to get that from the website into a Qlikview Document???

Many thanks in advance!!!

Reading information from a website. (How to include non table information??)

marcel_olmo — Mon, 24 Jan 2011 19:35:24 GMT

Hey guys, here's what I've found. I hope you find it useful.

First step download the HTML as plain file :

Web :

LOAD
recno() as Position,

@1:n as Code

FROM "http://www.example.com" (ansi, fix, no labels, record is line);

and then parse the resident table with your desired tabs with "textbetween" function :

Web2 :

load

TextBetween(Code,'Begin','End') as [Field]

resident Web;

Cheers!!

topic Reading information from a website. (How to include non table information??) in QlikView

Reading information from a website. (How to include non table information??)

Reading information from a website. (How to include non table information??)