Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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 .