topic Re: know the number of tables in QlikView

know the number of tables

ali_hijazi — Wed, 29 Jul 2015 11:51:20 GMT

Hello

I'm reading from sharepoint page (html)

in the URL I'm passing the ID of the employee

the problem is that the total number of tables differs from one ID to another

sometimes I get 40 tables named @1, @2,....@40 and for other ID values I get around 20 tables

the information that I'm looking for is 100% in the last table available

How can I know what is the last table to make reading dynamic as I'm making a loop through all employee IDs connect to the html page and read

Please advise

Re: know the number of tables

Gysbert_Wassenaar — Wed, 29 Jul 2015 14:12:07 GMT

Something like this might do the trick:

SET ErrorMode = 0;

For i = 999 to 1 Step -1

vTable = '@' & $(i);

MyTable:
LOAD * FROM http://myserver/mypage.html (html, codepage is 1252, embedded labels, table is $(vTable))

Exit For When NoOfRows('MyTable')

Next

SET ErrorMode = 1;

Re: know the number of tables

Fri, 07 Aug 2015 05:58:16 GMT

Other option is to use the load wizard in Qlikview and load view webfile then you can preview which table number is the right table.