topic Re: MYSQL Usage of Variable to Loop through 10 databases in QlikView https://community.qlik.com/t5/QlikView/MYSQL-Usage-of-Variable-to-Loop-through-10-databases/m-p/457966#M695372 <HTML><HEAD></HEAD><BODY><P>Yes, it's fairly easy. Take a look at the FOR EACH statement. </P><P></P><P>-Rob</P></BODY></HTML> Mon, 10 Jun 2013 22:20:51 GMT rwunderlich 2013-06-10T22:20:51Z MYSQL Usage of Variable to Loop through 10 databases https://community.qlik.com/t5/QlikView/MYSQL-Usage-of-Variable-to-Loop-through-10-databases/m-p/457965#M695371 <HTML><HEAD></HEAD><BODY><P>We are using MYSQL as the data source.&nbsp; We have the same 4 tables replicated for 10 different databases (one database for each one of 10 locations).&nbsp; </P><P></P><P>We'd like to concatenate all 10 versions of the 4 tables into 4 tables in QlikView and add the database name (database1 through database10) as a new field appended to the records in the data (ie database# as locationid).&nbsp; </P><P></P><P>Is it possible to loop through all 10 databases within a single script sequence without having to script and manually refer to each database individually and concatenate into the same set of 4 tables in QlikView?</P></BODY></HTML> Mon, 10 Jun 2013 21:14:13 GMT https://community.qlik.com/t5/QlikView/MYSQL-Usage-of-Variable-to-Loop-through-10-databases/m-p/457965#M695371 JulieKae 2013-06-10T21:14:13Z Re: MYSQL Usage of Variable to Loop through 10 databases https://community.qlik.com/t5/QlikView/MYSQL-Usage-of-Variable-to-Loop-through-10-databases/m-p/457966#M695372 <HTML><HEAD></HEAD><BODY><P>Yes, it's fairly easy. Take a look at the FOR EACH statement. </P><P></P><P>-Rob</P></BODY></HTML> Mon, 10 Jun 2013 22:20:51 GMT https://community.qlik.com/t5/QlikView/MYSQL-Usage-of-Variable-to-Loop-through-10-databases/m-p/457966#M695372 rwunderlich 2013-06-10T22:20:51Z