Synthetic keys generally represent a data quality problem or trap. Redundant fields should be removed. When multiple fields are required to make a link, they should be replaced with compound keys.
See https://qlikviewcookbook.com/resolving-synthetic-keys/
|