Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please gives us on pratical Example
It's the way Qlikview joins 2 tables with more than one columns named the same. Qlikview creates a temporary table and calls this a 'Synthetic Key'.
Hi Matthew,
I am the new user of Qlikview so can you please give me one simeple example for the same..
regards,
Yogesh
Hi Yogesh,
also please go through with this blog.
community.qlik.com/blogs/qlikviewdesignblog/2013/04/16/synthetic-keys
-- Regards,
Vishal Waghole
Hi Yogesh,
I suggest having a read of this thread
http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/16/synthetic-keys
hope that helps
Joe
Hi Yogesh,
Check this link,
www.learnallbi.com/qlikview-resolving-synthetic-keys/
good example to understand what is synthetic key and how to avoid it.
Hope you understand from this.
-- Regards,
Vishal Waghole
Are you used to dealing with data in SQL or similar? Normally you join columns explicitly, but Qlikview will join any columns with the same names so you have to be careful when naming your columns. You can avoid them by being more explicit in your LOAD (using JOINs) or creating new tables that link to others via one named column.
when we have more than one field common between 2 tables then we will get synthetic key.
ways to remove:
comment,
rename,
qualify,unqualify statements