topic Connecting to Multiple Databases in QlikView https://community.qlik.com/t5/QlikView/Connecting-to-Multiple-Databases/m-p/322253#M708249 <HTML><HEAD></HEAD><BODY><P>Hi Steven,</P><P></P><P>when loading two tables with same fields, QV appends the second table to the first one. If you don't want that behavior try to use a NOConcatenate LOAD like:</P><P></P><P>housing_asset:</P><P>NoConcatenate</P><P>LOAD</P><P>. . .</P><P>HtH</P><P>Roland</P></BODY></HTML> Fri, 23 Dec 2011 10:30:25 GMT 2011-12-23T10:30:25Z Connecting to Multiple Databases https://community.qlik.com/t5/QlikView/Connecting-to-Multiple-Databases/m-p/322252#M708248 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Do you know if it is possible to connect to multiple databases, and load the same table from each database. The screenshot below demonstrates my issue:</P><P><IMG alt="screenshot.bmp" class="jive-image-thumbnail jive-image" height="410" onclick="" src="https://community.qlik.com/legacyfs/online/9853_screenshot.bmp" width="750" /></P><P></P><P></P><P>I am trying to load the table entitled GL_ASSET from two databases. I have renamed one table Mainttest_asset and one housing_asset, yet despite connecting to both, it loads both tables as Mainttest_asset and when creating a chart, list box etc, I only see one instance of this table, with one set of data loaded in it. Despite this, it has loaded another table from the second database connection.</P><P></P><P>Is it therefore possible to load the same table from different databases if they have the same name?</P><P></P><P>Any help would be greatly appreciated</P><P></P><P>Regards,</P><P></P><P>Steven Prentice</P></BODY></HTML> Fri, 23 Dec 2011 10:21:35 GMT https://community.qlik.com/t5/QlikView/Connecting-to-Multiple-Databases/m-p/322252#M708248 2011-12-23T10:21:35Z Connecting to Multiple Databases https://community.qlik.com/t5/QlikView/Connecting-to-Multiple-Databases/m-p/322253#M708249 <HTML><HEAD></HEAD><BODY><P>Hi Steven,</P><P></P><P>when loading two tables with same fields, QV appends the second table to the first one. If you don't want that behavior try to use a NOConcatenate LOAD like:</P><P></P><P>housing_asset:</P><P>NoConcatenate</P><P>LOAD</P><P>. . .</P><P>HtH</P><P>Roland</P></BODY></HTML> Fri, 23 Dec 2011 10:30:25 GMT https://community.qlik.com/t5/QlikView/Connecting-to-Multiple-Databases/m-p/322253#M708249 2011-12-23T10:30:25Z