topic load tables using a loop in QlikView

load tables using a loop

Fri, 11 Mar 2011 16:40:30 GMT

Hello,

I would like to be able to load some tables since my database (All those who begin with ' QV ') by using a loop in the QV's script.

I don't know how to proceed because of my lack of experience on QV.

Thank you for your help.

Nabil

load tables using a loop

tresB — Fri, 11 Mar 2011 17:05:12 GMT

Look at the sample code :


LOAD *
FROM
T:\QuickView\practice\QV*.txt
(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

Hope this helps.

Regards, tresesco

load tables using a loop

Fri, 11 Mar 2011 17:12:29 GMT

Thanks for you're replay!

The tables are not in .TXT file!All my tables are on a Oracle database!

Any ideas?

load tables using a loop

Fri, 11 Mar 2011 17:15:26 GMT

Hi,

You can load the list of tables expected from system tables on your db (depending on the db you are dealing with) and iterate through the values to load tables.