topic Re: Loop through the same tables in multiple databases in QlikView

Loop through the same tables in multiple databases

Wed, 18 Mar 2015 03:25:21 GMT

I am working with an event management product that maintains separate MS-SQL databases for each event. One database keeps a list of all of the different databases. To create an app across all the databases, I need to create a loop that will

draw the database name from the list;
access the required database and tables;
store the tables into qvds with the database name at the front of the qvd name e.g. AT_4313_EventDemographics.qvd; then
move rinse repeat until all databases in the list have been addressed.

Any ideas?

Re: Loop through the same tables in multiple databases

arulsettu — Wed, 18 Mar 2015 04:10:17 GMT

check this

Connections with more than one databases in the same document

Re: Loop through the same tables in multiple databases

Wed, 18 Mar 2015 04:24:07 GMT

Worked like a charm - thanks. Now all I need to do is get the script to move on if there is an error.

Re: Loop through the same tables in multiple databases

arulsettu — Wed, 18 Mar 2015 04:40:38 GMT

if its is ok please close the thread by marking correct answer

thanks