topic Re: Challenge : Loading data from web when data table is at multiple pages in QlikView

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

shekhar_analyti — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

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

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 — Sun, 12 Mar 2017 11:26:30 GMT

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

(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))

));

shekhar_analyti — Sun, 12 Mar 2017 12:02:19 GMT

Thank you lironbaram ... You Rocked