1 Reply Latest reply: Jun 10, 2013 6:20 PM by Rob Wunderlich RSS

    MYSQL Usage of Variable to Loop through 10 databases

    Julie Whipple

      We are using MYSQL as the data source.  We have the same 4 tables replicated for 10 different databases (one database for each one of 10 locations). 

       

      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). 

       

      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?