Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
Partner
Partner

Loading multiple tables from one html file dynamically

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

 

 

 

 

 

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Loading multiple tables from one html file dynamically

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

It will ignore errors and keep executing the script;


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
MVP & Luminary
MVP & Luminary

Re: Loading multiple tables from one html file dynamically

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

It will ignore errors and keep executing the script;


talk is cheap, supply exceeds demand

View solution in original post

Digital Support
Digital Support

Re: Loading multiple tables from one html file dynamically

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

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.