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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniboy2019
Contributor II
Contributor II

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
Former Employee
Former Employee

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
Former Employee
Former Employee

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!