Challenge : Loading data from web when data table is at multiple pages

[shekhar_analyti]

Hi All ,

How to load Election Result data from a website when the data table is scattered at multiple pages .

Website : http://eciresults.nic.in/StatewiseS24.htm

Data pattern

My requirement is that my qvw app should load data one by one from the above web data table till it reaches end . Here its 41th page .

Thanks

[lironbaram · Accepted solution]

hi

this script will do what you ask for

for i=1 to 40

let vPage= 'StatewiseS24' &  if($(i)>1,$(i),'') & '.htm';

LOAD Constituency,

     [Const. No.],

     [Leading Candidate],

     [Leading Party],

     [Trailing Candidate],

     [Trailing Party],

     Margin,

     Status

FROM

[http://eciresults.nic.in/$(vPage)]

(html, codepage is 1252, embedded labels, table is @7, filters(

Remove(Row, Pos(Top, 2)),

Remove(Row, Pos(Top, 1)),

Remove(Row, Pos(Top, 2))

));

next

[shekhar_analyti]

Thank you lironbaram ... You Rocked