topic Loop on URL in QlikView

Loop on URL

Wed, 29 Feb 2012 06:53:21 GMT

Hi All,

I am trying to build a loop on a specific URL. Seem like loop itself is working but I cannot retrieve the records those to be appended. Any idea or help will be greatly appreciated.

Here is the script:

FOR i = 1 to 3

Set vURLStart = '[http://www.appdata.com/leaderboard/apps?fanbase=0&metric_select=mau&page=';

Set vURLMid = $(i);

Set vURLEnd = ];

LOAD F1,

Name,

MAU

FROM $(vURLStart) & $(vURLMid) & $(vURLEnd)

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

Best,

Piroglu1907

Loop on URL

CELAMBARASAN — Wed, 29 Feb 2012 06:59:41 GMT

Hi,

Try with this

FOR i = 1 to 3

Set vURLStart = '[http://www.appdata.com/leaderboard/apps?fanbase=0&metric_select=mau&page=';

Set vURLMid = $(i);

Set vURLEnd = ']';

LOAD F1,

Name,

MAU

FROM $(vURLStart) & $(vURLMid) & $(vURLEnd)

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

Hope it helps

Celambarasan

Loop on URL

Wed, 29 Feb 2012 07:04:10 GMT

Hi Celambarasan,

Appreciated your help. But it is still the same. Script seem to be reading 120 records on 3 pages (40 records each) but retrieved data is the only first 40.

What else shall I look into?

Best,

Piroglu1907

Loop on URL

CELAMBARASAN — Wed, 29 Feb 2012 07:06:50 GMT

Hi,

Did you tried with the table name before it?

FOR i = 1 to 3

Set vURLStart = '[http://www.appdata.com/leaderboard/apps?fanbase=0&metric_select=mau&page=';

Set vURLMid = $(i);

Set vURLEnd = ']';

TableName:

LOAD F1,

Name,

MAU

FROM $(vURLStart) & $(vURLMid) & $(vURLEnd)

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

Celambarasan

Loop on URL

vijay_iitkgp — Wed, 29 Feb 2012 07:06:58 GMT

Hi ,

I think you have defined vURLEnd incorrectly.

Set vURLEnd=']';

Hope this will work

Loop on URL

Wed, 29 Feb 2012 07:18:21 GMT

Hello All,

Its still not working despite adding table name and single quotation My script is as per following:

FOR i = 1 to 3

Set vURLStart='[http://www.appdata.com/leaderboard/apps?fanbase=0&metric_select=mau&page=';

Set vURLMid=$(i);

Set vURLEnd=']';

Records:

LOAD F1,

Name,

MAU

FROM $(vURLStart) & $(vURLMid) & $(vURLEnd)

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

Next

Best,

Piroglu1907

Loop on URL

Anonymous — Wed, 29 Feb 2012 07:28:14 GMT

Why not try is like this:

FOR i = 1 to 3

Set vURLMid = $(i);

LOAD F1,

Name,

MAU

FROM [http://www.appdata.com/leaderboard/apps?fanbase=0&metric_select=mau&page=$(vURLMid)]

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

Next i ;

Good Luck.

Dennis.

Loop on URL

vijay_iitkgp — Wed, 29 Feb 2012 07:44:17 GMT

Hi,

Try

Let vURLMid = $(i); instead of Set

Loop on URL

jagan — Wed, 29 Feb 2012 07:49:56 GMT

Hi,

Try this script,

Set vURLStart='[http://www.appdata.com/leaderboard/apps?fanbase=0&metric_select=mau&page=';

Set vURLEnd=']';

For i=1 to 3

Set vURLMid=$(i);

LET URL = vURLStart & vURLMid & vURLEnd;

LOAD *

FROM

$(URL)

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

Regards,

Jagan.

Loop on URL

Wed, 29 Feb 2012 07:52:01 GMT

Hello Dennis, Celambarasan and Vijay,

Thanks for your help. Dennis' suggestion worked well as per following:

FOR i = 1 to 3

Set vURLMid = $(i);

LOAD F1,

Name,

MAU

FROM [http://www.appdata.com/leaderboard/apps?fanbase=0&metric_select=mau&page=$(vURLMid)]

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

Next i ;

Best,

Piroglu1907