topic How to connect sales data from different sources in QlikView https://community.qlik.com/t5/QlikView/How-to-connect-sales-data-from-different-sources/m-p/369691#M702881 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am designing sales statistics but we are in process of changing our ERP and I will need to connect to sales data from Oracle database up to a specificic date and from SQL Server from this date on.</P><P>How can I merge sales data from both databases into one list in QlikView? Any script example? Thanks!</P></BODY></HTML> Thu, 26 Jul 2012 14:38:34 GMT 2012-07-26T14:38:34Z How to connect sales data from different sources https://community.qlik.com/t5/QlikView/How-to-connect-sales-data-from-different-sources/m-p/369691#M702881 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am designing sales statistics but we are in process of changing our ERP and I will need to connect to sales data from Oracle database up to a specificic date and from SQL Server from this date on.</P><P>How can I merge sales data from both databases into one list in QlikView? Any script example? Thanks!</P></BODY></HTML> Thu, 26 Jul 2012 14:38:34 GMT https://community.qlik.com/t5/QlikView/How-to-connect-sales-data-from-different-sources/m-p/369691#M702881 2012-07-26T14:38:34Z Re: How to connect sales data from different sources https://community.qlik.com/t5/QlikView/How-to-connect-sales-data-from-different-sources/m-p/369692#M702882 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can create a qvw like historicload and connect to ORACLE to load a historicsales.qvd.</P><P></P><P>Add one more script to load SQL data and concatenate with historicsales. Point is that both the scripts should return same fields.</P><P></P><P>Kiran Rokkam.</P></BODY></HTML> Thu, 26 Jul 2012 14:56:59 GMT https://community.qlik.com/t5/QlikView/How-to-connect-sales-data-from-different-sources/m-p/369692#M702882 2012-07-26T14:56:59Z