Synthetic keys importance

[sahaja_chinni]

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.

[Vegar]

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

[Brett_Bleess]

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