topic Re: Loading multiple tables from one html file dynamically in QlikView

Loading multiple tables from one html file dynamically

sanal_ELM — Sat, 16 Nov 2024 20:33:21 GMT

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

Re: Loading multiple tables from one html file dynamically

Gysbert_Wassenaar — Sun, 30 Jun 2019 15:37:55 GMT

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

It will ignore errors and keep executing the script;

Re: Loading multiple tables from one html file dynamically

Brett_Bleess — Mon, 29 Jul 2019 20:16:39 GMT

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