topic Re: Synthetic key problem in QlikView

Synthetic key problem

Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

I have 3 tables which has common field EmpId. When I am trying to form a connection with all tables it creates synthetic key. I need information from all table. Would anyone please explain me HOW TO MANAGE THIS? what should I do so It will be resolved and all information will be accessible. Find attached the screenshot.

Re: Synthetic key problem

Fri, 20 Jan 2017 10:19:33 GMT

Tables here

Asset Team

Empcode

Laptop Number

Version

Empcode

Salary

HRA

EmpDetails

Empcode

First Name

Last Name

Dept

Branch

Re: Synthetic key problem

swuehl — Fri, 20 Jan 2017 10:22:44 GMT

And the syn key table is made of which fields except Empcode? I see only a single key field between the 3 tables.

Re: Synthetic key problem

Fri, 20 Jan 2017 10:24:41 GMT

Yes. only EmpCode is sync key

Re: Synthetic key problem

devarasu07 — Fri, 20 Jan 2017 10:32:49 GMT

Hi,

Screen shot image missing in u r attachment and can you share your document. Please refer to my attachment, i don't see any synthetic key issue on u r listed table columns. Tks

Re: Synthetic key problem

stabben23 — Fri, 20 Jan 2017 10:41:31 GMT

Your tables(in Your example) will not generate any sync key, only a association between tables With fieldnam Empcode. You have a correct datamodel here.

Re: Synthetic key problem

Fri, 20 Jan 2017 10:55:34 GMT

Is it problem ? does it sync key? if not will provide correct result ? how sync key identified ?

Re: Synthetic key problem

devarasu07 — Fri, 20 Jan 2017 11:04:15 GMT

Hi,

Nope, this is not synthetic key, when we have more than one common field between two or more tables, QlikView creates “SYNTHETIC KEYS” and “SYNTHETIC TABLE”.

refer sample below article (attached synthetic key issue document)

https://www.analyticsvidhya.com/blog/2014/11/synthetic-keys-qlikview-simplified/

Hope this helps, Tks Deva

Re: Synthetic key problem

stabben23 — Fri, 20 Jan 2017 11:04:53 GMT

Congrats, you have made a "Perfect" datamodel. Sync key will show up as a "extra" tabel With all common Fields.

If you add ex 'dummy' as Dept in Your HR table you see whats happens.