.svg){kind=icon}
.gif)
.svg)
- Login and open Qlik Sense App and click your app from the hub to launch it.
- Go to Prepare from the top menu, then open the Data Load Editor.
- In the Data Load Editor, click Load data and review your load script and identify fields that appear in multiple tables (for example, Region and Region Code).
- In one of the tables, rename a duplicate field using AS (for example, Region as rg).
- Click Load data to reload the script and apply the changes.
- Open the Data Model Viewer to confirm the synthetic key has been removed.
How to Remove Synthetic Keys in Qlik Sense
📌 Why this matters
Why this matters
Synthetic keys are Qlik Sense's way of handling ambiguous data relationships, but they come with a cost; they slow down your app, make the data model harder to understand, and can cause incorrect associations between tables. Left unresolved, a single synthetic key can cascade into multiple compound keys that are nearly impossible to debug later. Cleaning them up forces you to define explicit, intentional relationships in your data model, which leads to faster load times and more predictable analysis. For teams sharing apps across departments, a clean data model also means anyone opening the app can trust the associations they see.
Your product deserves an interactive demo
