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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

load tables using a loop

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



3 Replies
tresesco
MVP
MVP

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

Not applicable
Author

Thanks for you're replay!

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

Any ideas?

Not applicable
Author

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.