Connection error is due to your connection failed....
Please use test connection while making ODBC connection.
Load Portfolio and Other 3 tables.
Load * From TableName;
Load * from Revenue2013TableName;
Load * from Revenue2012TableName
Load * From Revenue2011TableName
Left Join (Portfolio) Load * Resident [Revenue 2013];
Drop Tables Portfolio, [Revenue 2013];
Hope this help you...
I think this will do. But I cannot load table that are already in the QLikView document. Loaded table with Load is sought for in the directory where the QLikView document is saved.
more precisely, i have already loaded Portfolio, Revenue2011TableName, Revenue2012TableName, Revenue2013TableName. How can I load table that are already in the document ? Should i use another combo box item as connection ODBC ?