topic Routine for loading database tables in QlikView

Routine for loading database tables

Anonymous — Thu, 05 Jun 2014 07:53:03 GMT

Hi Guys,

I'm searching in a database for fields in curtain tables but I can't find want I'am looking for.

Therefor I want to load all tables in a QV document starting with a character (like 'CAQ' )using a routine function. Does anyone as an example for it? Thanks in advance.

Best regards,

Robert

Re: Routine for loading database tables

bbi_mba_76 — Thu, 05 Jun 2014 08:53:45 GMT

Hi,

maybe you could use some of similar

Tmp:

//sql server db

SELECT name FROM sys.Tables

//oracle db

//select Table_name as name from user_tables

where name like 'D_%'

;

qualify *;

LET v_rowTemp = NoOfRows('Tmp');

for i=1 to $(v_rowTemp)

LET v_tabname = peek('name',$(i)-1,'Tmp');

sql select * from $(v_tabname);

Re: Routine for loading database tables

Anonymous — Thu, 05 Jun 2014 09:15:04 GMT

thanks,

This works fine

Regards,

Robert

Robert Waterval

ICT

Koninklijke Mosa bv

Meerssenerweg 358

P.O. Box 1026

NL-6201 BA Maastricht

T +31 (0)43 368 8803

F +31 (0)43 363 11 77

robert.waterval@mosa.nl

www.mosa.nl<http://www.mosa.nl/>

<http://www.facebook.com/mosatiles> <http://www.linkedin.com/company/royal-mosa>

Van: Michele Barini

Verzonden: donderdag 5 juni 2014 10:54

Aan: Robert Waterval

Onderwerp: Re: - Routine for loading database tables

Qlik Community<http://community.qlik.com/>

Routine for loading database tables

reply from Michele Barini<http://community.qlik.com/people/BBI_MBA_76?et=watches.email.thread> in Scripting - View the full discussion<http://community.qlik.com/message/542404?et=watches.email.thread#542404>