Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

How to connect sales data from different sources

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!

1 Reply
Not applicable

Re: How to connect sales data from different sources

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.