Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Importing From a Website Question

So I did the data from web files thing and I put the website in and it comes up with the code below for the script. It works fine, the only problem is that this web page only has 100 listings. To get to the next 100, you have to go to the next page. The URL is the exact same except that the "200" in the URL becomes "300". I could just copy and paste this 50 times and keep changing the number, but I'm certain there is a better way of doing this. I'm pretty clueless when it comes to the script so any help would be appreciated.

LOAD Rank,
Region,
Character,
Points,
Wins,
Losses,
Ratio,
Division,
Age
FROM
[http://www.sc2ranks.com/ranks/all/diamond/1/all/points/200]
(html, codepage is 1252, embedded labels, table is @1);

Thanks in advance.

1 Reply
Not applicable
Author

Hello,

you can use a for ... next with a variable like this:


for vCounter=100 to 1200 step 100
Tbl:
LOAD Rank,
Region,
Character,
Points,
Wins,
Losses,
Ratio,
Division,
Age
FROM
[http://www.sc2ranks.com/ranks/all/diamond/1/all/points/$(vCounter)]
(html, codepage is 1252, embedded labels, table is @1);
next;


Regards, Roland