topic Re: Extract data from multiple data sources in QlikView https://community.qlik.com/t5/QlikView/Extract-data-from-multiple-data-sources/m-p/544170#M1268211 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>First design the data model for your document taking into account the field names and tables, and specify the fact table(s) and dimensions.</P><P></P><P>Then load from each source in turn:</P><UL><LI>set the connection string for the first source using CONNECT</LI><LI>load the data from this source, organised per your analysis. </LI><LI>connect to the second source (this automatically disconnects the first)</LI><LI>load the data from this source</LI><LI>and so on for all your sources ...</LI><LI>perform any final transformations&nbsp; etc</LI></UL><P></P><P>HTH</P><P>Jonathan</P></BODY></HTML> Tue, 19 Nov 2013 12:10:28 GMT jonathandienst 2013-11-19T12:10:28Z Extract data from multiple data sources https://community.qlik.com/t5/QlikView/Extract-data-from-multiple-data-sources/m-p/544169#M1268210 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have a data in excel ,sql server and other database.i have different tables in different dats source...now i want to make reports based on that..so how to do it,can any help me in detail@@@@</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Extract-data-from-multiple-data-sources/m-p/544169#M1268210 2026-01-26T18:19:17Z Re: Extract data from multiple data sources https://community.qlik.com/t5/QlikView/Extract-data-from-multiple-data-sources/m-p/544170#M1268211 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>First design the data model for your document taking into account the field names and tables, and specify the fact table(s) and dimensions.</P><P></P><P>Then load from each source in turn:</P><UL><LI>set the connection string for the first source using CONNECT</LI><LI>load the data from this source, organised per your analysis. </LI><LI>connect to the second source (this automatically disconnects the first)</LI><LI>load the data from this source</LI><LI>and so on for all your sources ...</LI><LI>perform any final transformations&nbsp; etc</LI></UL><P></P><P>HTH</P><P>Jonathan</P></BODY></HTML> Tue, 19 Nov 2013 12:10:28 GMT https://community.qlik.com/t5/QlikView/Extract-data-from-multiple-data-sources/m-p/544170#M1268211 jonathandienst 2013-11-19T12:10:28Z