Solved: Re: Data Modeling problem - Qlik Community

indiana256 · ‎2019-06-21

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 · ‎2019-06-21

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.

View solution in original post

felipedl · ‎2019-06-21

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 · ‎2019-07-22

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

Data Modeling problem

'data model'