Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
anushree1
Specialist II
Specialist II

Data merge

Hi,

I am working on a developed app for a enhancement; this app has a complex model with many tables (using link table) so there is a table which has divisions like 1, 2,3 ... 6, now the requirement is to merge the dimensions 4 and 5 and call it 7.

I would like to know the best approach to deal with this , would it better to do it in the last layer of the data model ; if yes , please suggest how

or should we start the merge at the beginning of the loading of tables ; please note divisions for different regions are coming from different sources with a need of transformation in qlik

1 Reply
ramasaisaksoft

As per my understanding &  knowledge ,

 

please do it with Resident load  for 4 and 5  tables and apply Concatenate  table as 7.

and all things if you have finished in Data model layer it will be good .