Recognize HTML tables by HTML tags

[sifatnabil]

Hi all,

On a website where I want to pull out the HTML tables, there are 2 tables that have the same fields but actually intend to show different data. How can I differentiate them? Would their HTML tags help? And their table numbers change, like today they could be @1, @2, tomorrow they might be @4, @7.

[Gysbert_Wassenaar]

The only was I know of is to simply load all tables (or at least the first record) and then check if the data is the data that you need. If it isn't then discard it, if it is then keep it.

[sifatnabil]

I'm currently doing that in my script but I'm not able automatically check if the data is from table "A" or "B". One table shows total volumes, the other table shows client volumes. So the data are both number values .

[Gysbert_Wassenaar]

If you can't tell from the data in the table then Qlikview can't distinguish between them. All Qlikview sees is the field names and the data.

[sifatnabil]

It looks like the webpage source code has commented lines of code identifying the different tables...any way to bring those into QV? I can see for example that using "Delimited" brings in the tags:

And the source code of the webpage has comments identifying the table. Could there by a way to match these up?