topic SV:looping the website in QlikView

looping the website

Thu, 20 Jan 2011 10:01:27 GMT

Hi ,

Consider i have an url http://en.wikipedia.org/wiki/Latitude_and_longitude_of_cities,_A-H which will show the data for the alohabets from A-H and http://en.wikipedia.org/wiki/Latitude_and_longitude_of_cities,_I-P

So is it possible to pass the parameter A-H and I-P to url and load the data from the website in to single table rather than loading in to multiple table and merging in to single table.

SV:looping the website

antose — Fri, 21 Jan 2011 17:04:38 GMT

Hi!

Try this:

SET vSource = If(i=1, '[http://en.wikipedia.org/w/index.php?title=Latitude_and_longitude_of_cities,_A-H&printable=yes] (html, utf8, embedded labels, table is @1)',
If(i=2, '[http://en.wikipedia.org/w/index.php?title=Latitude_and_longitude_of_cities,_I-P&printable=yes] (html, utf8, embedded labels, table is @1)',
If(i=3, '[http://en.wikipedia.org/w/index.php?title=Latitude_and_longitude_of_cities,_Q-Z&printable=yes] (html, utf8, embedded labels, table is @1)' )));

FOR i = 1 TO 3
LET vHttp = $(vSource);

Latitude:
LOAD *
FROM $(vHttp);
NEXT ;

SV:looping the website

Sun, 23 Jan 2011 21:57:00 GMT

Anders solution is OK, you can use also Concatenate load and subfield function to parse the field and create 2 new fields Latitude & Longitude

LOAD Country,
City,
[Latitude Longitude],
subfield( subfield( [Latitude Longitude] , '/' , 3) , ';' , 1) as Latitude ,
subfield( subfield( [Latitude Longitude] , '/' , 3) , ';' , 2) as Longitude
FROM
[http://en.wikipedia.org/w/index.php?title=Latitude_and_longitude_of_cities,_A-H&printable=yes] (html, utf8, embedded labels, table is @1);

CONCATENATE LOAD Country,
City,
[Latitude Longitude],
subfield( subfield( [Latitude Longitude] , '/' , 3) , ';' , 1) as Latitude ,
subfield( subfield( [Latitude Longitude] , '/' , 3) , ';' , 2) as Longitude
FROM
[http://en.wikipedia.org/w/index.php?title=Latitude_and_longitude_of_cities,_I-P&printable=yes] (html, utf8, embedded labels, table is @1);

CONCATENATE LOAD Country,
City,
[Latitude Longitude],
subfield( subfield( [Latitude Longitude] , '/' , 3) , ';' , 1) as Latitude ,
subfield( subfield( [Latitude Longitude] , '/' , 3) , ';' , 2) as Longitude
FROM
[http://en.wikipedia.org/w/index.php?title=Latitude_and_longitude_of_cities,_Q-Z&printable=yes] (html, utf8, embedded labels, table is @1);

Regards

Re: SV:looping the website

qlikviewforum — Mon, 20 Aug 2012 14:13:25 GMT

Hi All

The particular sharepoint where I am going to fetch the data needs authentication. Could you please let me how that can be done please.

Created the new thread for the same below.

http://community.qlik.com/message/249859#249859

Thanks,

qlikview forum