topic Re: Need Final Link Table in QlikView

Need Final Link Table

Thu, 26 May 2016 11:33:46 GMT

Hi,

I have made data model in which 4 to 5 table created and now want that all 4 to 5 table should link to one final table .

So that it data can be retrieve from one final Link table.

Please find the script of it.

Also suggest can we make the script more easy way rather than creating the big data model.

In every table transport_mode is different and same tables has been repeated.

Instead of using same table again and again what is the other workaround to create a good data model..

regards

Re: Need Final Link Table

marcus_sommer — Thu, 26 May 2016 14:40:50 GMT

You could simplify your datamodel if you don't split your shipping-data for the different transport_mode. There will be no advantage to split them and then creating complicated link-table structures to get them associated again. Keep it simple with one fact-table and if you then joined all measure-fields to the fact-table and keeped the other fields within associated dimension-tables - it will be probably work quite smoothly.

- Marcus

Re: Need Final Link Table

Fri, 27 May 2016 05:24:40 GMT

Hi,

Will you please help me in my attached data model.

Can you just make more simple script and send me.

I could not able to model it in simple way.

Will be very much helpful to me.

Regrads

Re: Need Final Link Table

marcus_sommer — Fri, 27 May 2016 06:56:47 GMT

Sorry, I couldn't build this datamodel for you. Without access to the data and a good understanding of the kind and quality of the data and the requirements which data-insights should be realized with them is it not possible to build a reliable datamodel and to gain these knowledge and to do the work needs more efforts then I could here provide and which would be also out of the scope of these community - to help others but do not their work.

My tip for you is that you build the datamodel step by step - at first the main-table (not splitted) and are there further fact-tables concatenate them and afterwards comes the joining/mapping of measure-fields to the fact-table and the other fields are placed in dimension-tables which are associated with the fact-table (is the dataset rather small the further measure-fields could be left within the dimension-tables - the performance-penalty of this would be lesser then the easier handling and logic within the datamodel).

I think further helpful will be the first two link-blocks from these document: Get started with developing qlik datamodels.

- Marcus