Merging data with old data

[narender123]

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

[Anonymous]

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

[Anonymous]

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