topic $SynTables in QlikView

$SynTables

jurciello — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: $SynTables

its_anandrjs — Fri, 29 Sep 2017 07:27:52 GMT

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

Re: $SynTables

jurciello — Fri, 29 Sep 2017 07:53:30 GMT

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 ?

Re: $SynTables

hic — Fri, 29 Sep 2017 07:58:09 GMT

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

Re: $SynTables

jurciello — Wed, 04 Oct 2017 08:20:01 GMT

Thanks to all for answers