Synthetic key problem

[#1]

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.

[#2]

Tables here  

Asset Team

Empcode

Laptop Number

Version

HR

Empcode

Salary

DA

HRA

EmpDetails

Empcode

First Name

Last Name

Dept

Branch

[swuehl]

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

[#4]

Yes. only EmpCode is sync key

[devarasu07]

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

[stabben23]

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.

[#7]

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

[devarasu07]

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

[stabben23]

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.