Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
slapbet94
Contributor
Contributor

Synthetic Key Question

Hello I created this data model in my Qlik app and although all the table fields have different names, Qlik still produces a synthetic key. Is that something that I can avoid or should I just leave it as it is? Thanks

Other (1).jpeg

 

Labels (1)
2 Replies
Mark_Little
Luminary
Luminary

Well it is best practice to avoid them, as it can cause the apps to be slow if there is a lot of data. 

It will happen when you have the field on multiple tables with the same name, If you share your Data model view from qlik we could probable advise how to fix

BrunPierre
Master
Master

Multiple synthetic keys are often an indication of a bad data model. They may be handled gracefully or may require excessive memory and time. Ideally, you should remove all synthetic keys from your script as a best practice.

More here  Handling synthetic keys    Synthetic keys