Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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.

Community Browser