topic Synthetic keys importance in QlikView

Synthetic keys importance

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

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.

Re: Synthetic keys importance

Vegar — Tue, 02 Apr 2019 04:40:28 GMT

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-keys.htm

Re: Synthetic keys importance

Brett_Bleess — Wed, 15 May 2019 18:13:07 GMT

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_discussion=true&filter=location&location=blog-board:qlik-design-blog&q=Synthetic%20Keys&search_type=thread

Regards,
Brett