Qlik Community

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniboy2019
Contributor
Contributor

Connection to SQL databases

Buenas tardes, soy Daniel, tengo un detalle algo a la hora de integrar mis mesas. Tengo un servidor que alberga 5 bases de datos con diferentes nombres, pero contienen 12 tablas iguales, su estructura es la misma, solo cambia el nombre de la base de datos y los registros. Como podría crear un script que me ayude primero a descargar datos de DB-1 y de ahí DB-2, de ahí DB-3, ayúdenme 😞

Labels (2)
1 Solution

Accepted Solutions
Caterina_Fruci
Support
Support

Hello @Daniboy2019 

Based on the description provided and since you have databases with different names and tables with the same name you could simply rename the tables with a suffix related to your DBs and use the QUALIFY statement before loading. Please find below how to use it: 

https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegu...

Thanks!

View solution in original post

1 Reply
Caterina_Fruci
Support
Support

Hello @Daniboy2019 

Based on the description provided and since you have databases with different names and tables with the same name you could simply rename the tables with a suffix related to your DBs and use the QUALIFY statement before loading. Please find below how to use it: 

https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegu...

Thanks!