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