https://community.qlik.com/t5/QlikView/Data-merge/m-p/1858950#M1216032 <P>Hi,</P> <P>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.</P> <P>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</P> <P>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</P> Sat, 13 Nov 2021 12:38:16 GMT anushree1 2021-11-13T12:38:16Z https://community.qlik.com/t5/QlikView/Data-merge/m-p/1858950#M1216032 <P>Hi,</P> <P>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.</P> <P>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</P> <P>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</P> Sat, 13 Nov 2021 12:38:16 GMT https://community.qlik.com/t5/QlikView/Data-merge/m-p/1858950#M1216032 anushree1 2021-11-13T12:38:16Z https://community.qlik.com/t5/QlikView/Data-merge/m-p/1859201#M1216048 <P>As per my understanding &amp;&nbsp; knowledge ,</P> <P>&nbsp;</P> <P>please do it with Resident load&nbsp; for 4 and 5&nbsp; tables and apply Concatenate&nbsp; table as 7.</P> <P>and all things if you have finished in Data model layer it will be good .</P> <P>&nbsp;</P> Mon, 15 Nov 2021 08:53:46 GMT https://community.qlik.com/t5/QlikView/Data-merge/m-p/1859201#M1216048 ramasaisaksoft 2021-11-15T08:53:46Z