Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

know the number of tables

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

I can walk on water when it freezes
2 Replies
Gysbert_Wassenaar

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;


talk is cheap, supply exceeds demand
Not applicable

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.