Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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