Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

narender123
Valued Contributor

Merging data with old data

Hi All,

Last year I created qlik view dashboard having multiple reports which is heaving data upto year 2014 .Having joining showed in attached file.

Now the database has been changed so we have created a oracle view for new database in which all the tables columns data is placed (after 2014 year data) in single view.I want to merge this view(new database view) in previous data modeling of qvw file (old database tables). How can i achieve this?

Thanks

Narender

                                   

                                       

11 Replies
roger_stone
Contributor III

Re: Merging data with old data

I think you'll need to explain a bit more about the old database and new database. For starters - Is the old database now static? Does the new database have the same column names as the old one?

narender123
Valued Contributor

Re: Merging data with old data

Hi Roger,

Thanks for your reply.


My Old database tables showed in attached file.


and my NEW Database having multiple tables with different data columns with different table structure .

So i have created a view which is having all requirement columns in single view(having internal joined tables).


View having:

"all columns of previous database tables" ;


means all columns of each one table of previous tables.


I want to merge this view into previous data modeling in .QVW file.


balrajahlawat
Esteemed Contributor

Re: Merging data with old data

If your new database tables have same fields like you were having earlier, then you just need to connect with new database and load the data...

Else if their are new tables, new Fields, updated field names, then you need to do data modeling from scratch....

roger_stone
Contributor III

Re: Merging data with old data

I think we're missing some vital information here. All I see is your original Doc1.docx.

balrajahlawat
Esteemed Contributor

Re: Merging data with old data

If your View is having all columns of Previous db tables, just load your data after making connection with new data view..

Highlighted
sfatoux72
Valued Contributor

Re: Merging data with old data

Hi Narender,

I don't know if you still have access to your old database and if so how long you will have access.

You need to start extracting data from your old QlikView application and save them to files QVD (if you don't know how to do that, see Reload QlikView Application (QVW) File Without Access To Data Source(s) for example).

On your new application, you will start to load your QVDs (or load your old application binary file if you prefer), after you will connect to your new database and do for each table a request on your view with only the requested fields.

For dimension tables you will need only to add new entry (use the "exists" function in the where clause).

narender123
Valued Contributor

Re: Merging data with old data

Hi Balraj,

I have created a view of my new database tables which i need.In this view i have all columns which are in my previous qlikview reports\Data Modeling.So when i merge that view in my previous database modeling then it is creating loop from all tables of my previous database.To avoid this i have remove association from my previous database modeling and join all previous table in single table so that i can merge this final table with my new database view.But the problem is that after join all tables into single table it is showing wrong data.As previous database modeling is created via association not from join.

Thanks,

narender123
Valued Contributor

Re: Merging data with old data

Hi Roger,

Please see my reply in Balraj Ahlawat.I think that one clear you.

Thanks,

narender123
Valued Contributor

Re: Merging data with old data

Hi Sebastien,

Please see my reply in Balraj Ahlawat. I think that one clear you.

Thanks,

Community Browser