Data Modeling problem

[indiana256]

Hi everyone,

this is my Data Model. The data table has several relationships. Is there any way to split "Cta" and "Fecha" key fields into two different? I need them to be independant.

Hope you can help me

Thanks in advance

[felipedl · Accepted solution]

Make a composite key of the Cta and Fecha fields and comment them on "Presup*" tables.

Only leave the separate fields on the datos tables, so it can link up to the calendar and Cuentas tables.

Another thing you could do, since they're common fields on multiple tables, is to join them so that all "Presup*" tables are merged into one single table.

Datawise they'll be independent, since the combination of both fields will occur on specific dates (i'm assuming that's what "datos" means), giving you independency on the main table.

[Brett_Bleess]

Here is another Design Blog post that may be useful to you:

https://community.qlik.com/t5/Qlik-Design-Blog/Synthetic-Keys/ba-p/1472634

Regards,
Brett