topic Re: Merging data with old data in QlikView

Merging data with old data

narender123 — Wed, 09 Dec 2015 06:58:19 GMT

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

Re: Merging data with old data

roger_stone — Wed, 09 Dec 2015 10:35:42 GMT

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?

Re: Merging data with old data

narender123 — Wed, 09 Dec 2015 12:44:40 GMT

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.

Re: Merging data with old data

Anonymous — Wed, 09 Dec 2015 12:48:59 GMT

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....

Re: Merging data with old data

roger_stone — Wed, 09 Dec 2015 12:49:12 GMT

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

Re: Merging data with old data

Anonymous — Wed, 09 Dec 2015 12:50:26 GMT

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

Re: Merging data with old data

sfatoux72 — Wed, 09 Dec 2015 13:44:33 GMT

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).

Re: Merging data with old data

narender123 — Mon, 14 Dec 2015 06:26:52 GMT

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,

Re: Merging data with old data

narender123 — Mon, 14 Dec 2015 06:29:16 GMT

Hi Roger,

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

Thanks,

Re: Merging data with old data

narender123 — Mon, 14 Dec 2015 06:30:05 GMT

Hi Sebastien,

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

Thanks,

Re: Merging data with old data

Anonymous — Mon, 14 Dec 2015 06:34:36 GMT

Creating Loop?

For wrong Data you can maintain a Flag as well, like this:

How it can create loops, if you are having tables like this, I dont think it will create loop!!

OldDataTable:

Load

ID,

'OLD' as Flag

Sales

From OLDDataTable;

You can use Concatenate here else QV auto concatenate this.

NewDataTable:

Load

ID,

'New' as Flag,

Sales

From NewDataTable;

Are you doing like this???

Also, merge/concatenate the old & new data at Raw/Stage1 level itself i.e before transformation

Re: Merging data with old data

Anonymous — Mon, 14 Dec 2015 06:36:22 GMT

If it still give you same output, after following my suggestion, I would say, please share some sample data...

You can scramle your data before sharing