Why don't you cicle through each table and then drop the ones you don't need.
set ErrorMode = 0; for i = 1 to 100 Table1: LOAD * FROM [http://community.qlik.com] (html, codepage is 1252, embedded labels, table is @$(i)); Let vRows = NoOfRows('Table1'); if vRows <> 10 then drop table Table1; ELSE exit for; endif next set ErrorMode = 1;
Thank you for your answer. Unfortunately, I have to loop over 10.000 html pages (dynamically generated) containing some 40 rather extensive tables. Loading them all is not an option 'cause that will take all day
At the moment, I'm doing some 'educated guesses' and load three tables which are the most likely and check if any of thoose correspond.