Loading multiple tables from one html file dynamically

[sanal_ELM]

Hi Team,

Actual requirement is here that loading multiple tables from one HTML file. The number of tables may change from file to file(No Static).So I tried with the loop and to fetch one by one tables from the HTML file. But if the particular  tablenot found then it is throwing some error and stop the execution. " would like to read all the available tables from the file without getting the error message .I want to exclude the unavailable tables from the file".

Ex:

HTML File Name:XYZ.HTML

Table name:@1,@2,@3,@4.......

i maximum value will be 25

Do while  i<25

 Load * From [...\path\XYZ.HTML]

(html.codepage is 1252,embedded labels,table is @$(i));

//Here doing some transformation and storing to qvds.

i=i+1;

loop

Note: I am getting an error "can not the locate the table in HTML File."

Regards,

Sanal

[Gysbert_Wassenaar · Accepted solution]

Put this line at the start of the script: set ErrorMode=0;

It will ignore errors and keep executing the script;

[Brett_Bleess]

The following may help as well, not certain:

https://community.qlik.com/t5/Qlik-Design-Blog/Loops-in-the-Script/ba-p/1473543

Regards,
Brett