Common challenges of Data modeling
When you start data model for your Qlik Sense application which involves linking tables together, you may come across common challenges which may make your data model behave unexpectedly.
Let us have a look at some of the challenges which you may come across.
Synthetic Keys
Qlik Sense developers are aware that whenever you have common field names in two or more tables, Qlik Sense links them together automatically. When you have one field which is common, then you don't have a problem; it is a clean linking between them. However, when you have two or more fields that are common, Qlik automatically generates the synthetic keys and synthetic table.
Note
Every time you reload the script, and if it contains the linking of a table with two or more common fields, Qlik Sense gives you a warning about the script containing synthetic keys. This clearly implies that you need to review your data model. Having synthetic keys may not create initial performance issues, but...
