Databases Reference
In-Depth Information
When we open the table viewer we notice that the data model contains a synthetic
key table named
$Syn1
. We were introduced to synthetic keys in
Chapter 4
,
Data
Modeling
. In the next section we will see a practical example of how to resolve
this issue.
Making it all right
Remember how QlikView's associative logic works? It automatically associates fields
that have the same name. And those associations between tables can only be based
on a single field. Well, the
Aircraft Types
and
Aircraft Types 2010
tables that we
loaded contain seven fields that match between these tables. To resolve this issue
QlikView created a synthetic key by creating a key for each unique combination of
the seven fields.
