Many thanks for your reply. So you mean to say that it will append the data.
For example, If I do something like below one
ODBC CONNECT TO YEAR2008;
ODBC CONNECT TO YEAR2009;
CONCATENATE SQL SELECT...
Then bill will contain both the years of data. In short you mean to say that it will append the data and it will not delete.
Please correct me if I am wrong!
As databases are not retrieved to QlikView, their structure is not so important. First you will need to load all necessary tables from one database then from the other.
Regardless your tables follow the same schema, you can force concatenate (append) one table to the other, so all results from one year will be added to the other table. So your script, should look like
ODBC CONNECT TO Y0002009;Clients:LOAD *;SQL SELECT * FROM Clients_2009;Invoices:LOAD *;SQL SELECT * FROM Invoices_2009;ODBC CONNECT TO Y0002010;CONCATENATE (Clients) LOAD *;SQL SELECT * FROM Clients_2010;CONCATENATE (Invoices) LOAD *;SQL SELECT * FROM Invoices_2010;