Synthetic key

[qlikview979]

Hi experts,

What is synthetic key ?

[marcus_malinow]

A synthetic key is where you have two or more fields linking two or more of your tables.

In such situations it's advisable to resolve this issue by either renaming fields, or concatenating them together to create a composite key.

See this post Synthetic Keys‌

[buzzy996]

syntthetic keys will be generated in tables because of the same kind of 2 or more fields combination in different tables,so by using concatenate key we can resolve these kind of issues

[qlikview979]

Thanks,

Marcus.