topic Re: Script to get all tables from a single database in QlikView

Script to get all tables from a single database

Mon, 29 Aug 2011 12:33:02 GMT

Hi,

In my database, there are 90 tables. I need all those tables into my qlikview.

Can anyone tel me how to write script with 'for each' statement ??

Thanks and regads,

Guru

Re: Script to get all tables from a single database

christian77 — Mon, 29 Aug 2011 12:52:27 GMT

When you click the Select button, you see a DB dialogbox. Select your tables and click on add.

When you have added all, finish it.

You may want to use the file attached. The autor of the file is not me. I downloaded from this community.

Script to get all tables from a single database

martinpohl — Mon, 29 Aug 2011 13:06:47 GMT

Hello Guru,

try this

CONNECT TO your database

T2:
SQLTables; //read database information
T1: load chr(39)&concat(TABLE_NAME,chr(39)&', '&chr(39))&chr(39) as tabs resident T2 where TABLE_TYPE='TABLE';
let tabs=peek('tabs',0,'T1'); // only load tables

for each tab in $(tabs)
sql select * from $(tab);
next //select all fields from all tables

maybe use a qualify?

Regards