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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ODBC with links on tables.

Greetings everyone, im a bit stuck with something i was asked to if i could do at work, but i dont really know where to start or how i should go about it, so here it goes.

Im loading a a table from a ODBC database, so far so good, this tables contains several  fields, and one of the fields contains table names. eg

idcompany
erros
Table_name
123A12tableA
456B6tableB
789C7tableC
323D9tableD

So what i need now, is being able to click on Table A and Qlikview Loads Table A.

But this works as following, the main table the one that i show here is different day by day, so in this case it returned company A,B,C and D but tomorrow it might show company F,H,K,T, therefore im going to need to load this main table everytime, to see what Companies it returns, then i want to be able to click or be able to select somewhere the corresponding table for that company.

Now i could just load all TableA to TableZ and then just need a multibox select to view the table i needed, but for that i would need to load all Tables from the get go, and for optimum speed, i would like to be able to just load the table once clicked or selected.

Many Thanks

0 Replies