Loading multiple tables from one html file dynamically
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".
HTML File Name:XYZ.HTML
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.
Note: I am getting an error "can not the locate the table in HTML File."