Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
How can I merge sales data from both databases into one list in QlikView? Any script example? Thanks!
Hi,
You can create a qvw like historicload and connect to ORACLE to load a historicsales.qvd.
Add one more script to load SQL data and concatenate with historicsales. Point is that both the scripts should return same fields.
Kiran Rokkam.