Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
brunolelli87
Creator II
Creator II
‎2020-04-28 02:49 PM

Connecting with a Web DataBase

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:

  1. 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)?
  2. 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,

288 Views
0 Likes
0 Replies