How to Remove Synthetic Keys in Qlik Sense

This tutorial shows how to identify and remove synthetic keys in Qlik Sense by renaming or qualifying fields in the Data Load Editor.

Note:

Synthetic keys appear when two or more tables share more than one common field name. Changes are made in the Data Load Editor using Qualify, Rename, or field removal.

1. Login and open Qlik Sense App and click your app from the hub to launch it. 
2. Go to Prepare from the top menu, then open the Data Load Editor.
3. 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).
4. In one of the tables, rename a duplicate field using AS (for example, Region as rg).
5. Click Load data to reload the script and apply the changes.
6. Open the Data Model Viewer to confirm the synthetic key has been removed.