Connecting with a Web DataBase

brunolelli87 — Wed, 25 Nov 2020 16:16:04 GMT

Dears,

There is a very nice website with some brazilian stock market information (https://statusinvest.com.br), and you can check each company by adding the company sticker at the end of the website link (https://statusinvest.com.br/acoes/cvcb3).

It's easily possible to connect QlikView with this website and collect all tables available for each company.

My question is:

How can I connect and collect information from all tables, for all the companies I'm looking for (CVCB3, ITUB4, AZUL4, GOLL4, BBAS3, BBDC4, HGTX3 and IGTA3)?
When loading the tables, I believe the right thing to do is to transpose the tables, and in this case I would have to add a new column on each table, to identify the company. How can I do it?

Thank you so much,
Best regards,

topic Connecting with a Web DataBase in QlikView