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.
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.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
.png "Former Employee"){kind=icon}
