Dealing with synthetic keys

[#1]

Hello!

I have several tables in my Qlikview, the picture of my data model in the attached file.

As you see I have three similar columns in 2 tables, thus Qlikview created a synthetic table. The thing is I just cant  rename these columns, 'cause I need to connect these  two tables according to these 3 columns, meaning all the three columns are keys.

It's working normally with synthetic keys right now, but i guess it's not right having them in my data model.

Any ideas on how to deal with them?

[alexandros17]

Take a look at this document:

[qlikmsg4u]

Create composite key using those common keys

[tyagishaila]

Hi,

You must try to generate star schema Data model, i.e. there should be 1 fact table.

It should be done when qvds are created. either by joining tables or concat tables.

OR

if you need only removal of synthetic table. For this create composite key in both tables with same name(by adding all three common fields), this single composite key will use for association and simultaneously rename all common fields.

Hope it will help you!

[jonathandienst]

If the composite key is the correct association in the model, there is no reason to remove the key. It it is not, then you will need to reconsider your model design.

It is usually unnecessary to create a composite key -- you are manually doing what the synthetic key is already doing for you.

See this article for more:

Synthetic Keys