Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Can we do union of 2 data source (Oracle and CSV data) in single QVD?

Hi Exports...

I am new to Qlikview, Could any one help me on below requirements.


Requirement:

Client is using application A for its day to day work management, on this application A there is one very critical Qlikview report is running. Now client is started migrating all its business from application A to Application B. However this migration is not one time migration, it is phase by phase migration. To complete this App A to App B migration it may take 3 to 4 years.

Now my job is to make sure during the phase by phase migration, QlikView report should display data from both system. when migration complete and application A goes off, then Qlikview report should display data only from App B.

Solution:

I have one very simple solution of Union of data set, to handle this phase by phase change i.e. I will use union of both both application database in QVD so there is no need to do any change in QVW files, it will save lot of time.

Now I am not sure how can I make union of App A data base which is on Oracle with application B data which we will be getting in CSV format files in one QVD.

Can we do union of 2 data set, in which one is getting from Oracle db, and other sources is getting from CSV file.

It will very helpful if you can put code in this discussion.

Thanks for your help and support for the same!

Regards,

-V

1 Reply
jagan
Not applicable

Re: Can we do union of 2 data source (Oracle and CSV data) in single QVD?

Hi,

You can do union in Qlikview by using Concatenate(), please find below sample script

Data:

SELECT

*

FROM DataSource1;

Concatenate(Data)

LOAD

*

FROM FileName.csv;

STORE Data INTO Data.qvd;

Hope this helps you.

Regards,

jagan.