Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 😞
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!
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!