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).
"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.
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.
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!!
'OLD' as Flag
You can use Concatenate here else QV auto concatenate this.
'New' as Flag,
Are you doing like this???
Also, merge/concatenate the old & new data at Raw/Stage1 level itself i.e before transformation
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).