Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
What is Synthetic Key and How to avoid it in qlikview?
Thanks in Advance,
Leela Madhav
HIC
When two or more input tables have two or more fields in common, this implies a composite key relationship
In this example SalesOrderNumber and SalesOrderLineNumber are Synthetics Keys:
Posible solutions:
Thanks for information
Regards
Leela Madhav
Thanks for information
Regards
Leela Madhav
Dear Leela,
Synthetic key can be removed by various ways most of them are given below,
1. By renaming the field names using these specifier: Qualify/UnQualify, Rename Field, Alias, AS
2. Concatenate Table
3. Create Link Table
Kind regards,
Ishfaque Ahmed
if you have more than one common field between two tables then it create synthetic key.
we can avoid it by using qualify, join ,concatenation and link table.
it means two or more fields have in more than one table it is synthetic key and
it is avoid the rename the field name, remove the fields names , by using the qualify and unqualify and autohash128or autohash256