I ran into another issue with the dashboard I am creating using 2 data bases.
Right now I am using 3 tables (Customer,Orders, and Order details) from each database for a total of 6 tables.
I do a normal load for the 3 tables from the main database. Customers from the old database is concatenated with customers of the new. Old order details is temp loaded with a left keep to a temp old orders table. Both are resident loaded with the reduced data and concatenated to Orders and Order details respectively. I then drop the temp tables.
The all works great and I have the links working so I can select a customer and see orders from both data sources.
My issue arises when I want to combine Territories from both data sources into one field. In the main database this field is stored on the Customer table. In the old database it resides in the Order table. I created an if statement so that the field names would match up with the main database. My issue now is that how can I combine these fields when they reside on different tables? I tried just leaving the names the name to let qlikview create a link, but this screws up my other connections an I lose data. In all of my other situations I just concatenated the tables to achieve this, but I can not do that here. I also tried to see if I could do another resident load of the old ordertemp table, and then concatenating that to the Customer table but I receive an error.
