Qlik Community

QlikView Integrations

Discussion Board for collaboration on QlikView Integration.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

List of Tables

Hi,

maybe someone of you can help me.

We have a database where I take Datas from.

We take this datafields out of tables from the database.

Now my question:

I dont Need datas from a table but a list of all tables within the database.

How can I realise that?

Our IT-Guy wrote to me the following, but unfortunately qlikview cannot handle this:

 

select

substr(segment_name,1,30) segment,

substr(segment_type,1,10) typ,

bytes/1024/1024 MB

from dba_segments

where segment_type = ‘TABLE’

Thanks in advance

Chris

10 Replies
flipside
Specialist II
Specialist II

Try this ...

Table1:

Load *;
SQLTABLES;

qualify *;
Table2:
Load * resident Table1 where TABLE_TYPE='TABLE';
unqualify *;

drop table Table1;