Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
sahaja_chinni
New Contributor

Synthetic keys importance

Can someone please explain about the concept of synthetic keys and their usage if any. Want to know how a synthetic table is formed when two tables are joined and two tables are concatenated.
2 Replies
Vegar
Honored Contributor

Re: Synthetic keys importance

I think the Qlik Sense Help are defining and explaining the synthetic keys in a good way. The concept of composite keys are handled the same in both QlikView and Qlik Sense.

I quote:
When two or more data tables have two or more fields in common, this suggests a composite key relationship. Qlik Sense handles this by creating synthetic keys automatically. These keys are anonymous fields that represent all occurring combinations of the composite key.

Read more at https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/synthetic-...
Please ekskuse my Norglish and Swenglish typos.
Support
Support

Re: Synthetic keys importance

Here is a Design Blog post as well that may be of some use in explaining things too:

https://community.qlik.com/t5/Qlik-Design-Blog/Synthetic-Keys/ba-p/1472634?advanced=false&collapse_d...

Regards,
Brett

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.