Discussion Board for collaboration on QlikView Scripting.
I want to use two database in one script? It is possible? I need it because our company have two different plants with different plantkeys and different database.
Now I use like the picture:
The problem I have only the data of the second plant.
What can I do?
Thanks for your help.
Try like this:
ODBC CONNECT TO <First connection string>;
Script here to load from first DB;
ODBC CONNECT TO <Second connection string>;
Script here to load from second DB;
You can load data from as many databases as you want, but keep in mind that you are only allowed to work with one at a time. So, for what you are trying to achieve you need to do like:
1. Connect to database A
2. Load data from database A
3. Connect to database B
4. Load data from database B
If the loads have the same structure (number of fields, name of the fields) the data will be concatenated and a sigle table with information from both databases will be created.
Hope that helps,
Hey Sven Arnold,
A "QVD Generator", or better a QVD layer, is probably a good idea in your case.