Synthetic table and Synthetic keys gets created when there are more than one common fields between the 2 or more tables.
QlikView associates tables based on the common field names in the tables and if there is more than one common field then QlikView creates synthetic tables. Synthetic keys are not beneficial in datamodel because they are resource intensive and may slow down calculations.They also make datamodel hard to understand. Synthetic keys should always be resolved.
- I have loaded 3 tables Products,Orders and OrderDetails
- Load the table and analyze your data model in Table viewer and observe the joins
- Make sure that Table associates only on the required fields. since Products and OrderDetails table are linked on ProductID, we can remove Unitprice from the table. You can do so either by commenting Unitprice or renaming it. Let us rename Unitprice in Products table by using “AS”
- Now load the tables again and check the Table viewer. Observe that Synthetic table/Key is removed and Products and OrderDetails are linked on ProductID.
Please watch my video to see in detail