Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
jurciello
Contributor III
Contributor III

$SynTables

Hi, everyone.

In case when we have got a synthtable, we are going to avoid it, creating link table (simply own-created table) in the load script. For example Table1(fields: a,b,c,d), Table2(fields: a,b,c,x,y,z). After that Table1(fields: d),linktable(a&b&c,a,b,c), Table2(fields:x,y,z). But, in some more complex cases of Data Models QV takes off some fields from linktable and put them into $SyntTable. Can anyone explain me purpose of this action?


Best regards ,

YuCH

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

The QIX engine will create a synthetic table as soon as there is more than one key between tables. So it is basically the engine's way of creating an internal link table. See more on Synthetic Keys

HIC

View solution in original post

4 Replies
its_anandrjs

It is to maintain the unique key combination between the tables that is the purpose.

jurciello
Contributor III
Contributor III
Author

So, when Developer performs link via linktable(correct from his point of view) but QV appologize that such link doesn`t perform unique key combination. That`s why QV creates it`s own $Synth ?

hic
Former Employee
Former Employee

The QIX engine will create a synthetic table as soon as there is more than one key between tables. So it is basically the engine's way of creating an internal link table. See more on Synthetic Keys

HIC

jurciello
Contributor III
Contributor III
Author

Thanks to all for answers