topic Load data from two different datasources in LINK table in QlikView https://community.qlik.com/t5/QlikView/Load-data-from-two-different-datasources-in-LINK-table/m-p/251179#M95332 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: verdana, geneva;">Hi there,</SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">I'm wondering if you guys know a solution for my problem.</SPAN></P><P><SPAN style="font-family: verdana, geneva;">The thing is that I am loading data from two different sources.</SPAN></P><P><SPAN style="font-family: verdana, geneva;">Both of them have a CUSTOMER table, which I would like to use in my QV doc.</SPAN></P><P><SPAN style="font-family: verdana, geneva;">There is a key between those two tables (databasetable1.customerid = databasetable2.customerid), so this far no problem.</SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">In database 1 I have SALES. In the SALES table is a key to the CUSTOMER table.</SPAN></P><P><SPAN style="font-family: verdana, geneva;">In database 2 I have CONTACTS. In the CONTACTS is a key to the CUSTOMER table in database 1.</SPAN></P><P><SPAN style="font-family: verdana, geneva;">See the attached file for the structure.</SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">The problem is that I would like to use a LINK table, but with this structure I think it is impossible. Is that right?</SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">Kind regards,</SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">Henco</SPAN></P><P></P><P></P><P><SPAN style="font-family: verdana, geneva;">EDIT: </SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">The reason why I use a LINK table is because of the other data I am loading. Such as dates (mastercalendar) and other fields which are the same in different tables.<BR /></SPAN></P></BODY></HTML> Sat, 10 Sep 2011 12:42:45 GMT Anonymous 2011-09-10T12:42:45Z Load data from two different datasources in LINK table https://community.qlik.com/t5/QlikView/Load-data-from-two-different-datasources-in-LINK-table/m-p/251179#M95332 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: verdana, geneva;">Hi there,</SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">I'm wondering if you guys know a solution for my problem.</SPAN></P><P><SPAN style="font-family: verdana, geneva;">The thing is that I am loading data from two different sources.</SPAN></P><P><SPAN style="font-family: verdana, geneva;">Both of them have a CUSTOMER table, which I would like to use in my QV doc.</SPAN></P><P><SPAN style="font-family: verdana, geneva;">There is a key between those two tables (databasetable1.customerid = databasetable2.customerid), so this far no problem.</SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">In database 1 I have SALES. In the SALES table is a key to the CUSTOMER table.</SPAN></P><P><SPAN style="font-family: verdana, geneva;">In database 2 I have CONTACTS. In the CONTACTS is a key to the CUSTOMER table in database 1.</SPAN></P><P><SPAN style="font-family: verdana, geneva;">See the attached file for the structure.</SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">The problem is that I would like to use a LINK table, but with this structure I think it is impossible. Is that right?</SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">Kind regards,</SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">Henco</SPAN></P><P></P><P></P><P><SPAN style="font-family: verdana, geneva;">EDIT: </SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">The reason why I use a LINK table is because of the other data I am loading. Such as dates (mastercalendar) and other fields which are the same in different tables.<BR /></SPAN></P></BODY></HTML> Sat, 10 Sep 2011 12:42:45 GMT https://community.qlik.com/t5/QlikView/Load-data-from-two-different-datasources-in-LINK-table/m-p/251179#M95332 Anonymous 2011-09-10T12:42:45Z