When we load two tables with a common field name in both tables, the tables get associated automatically based on the common fields. This is the associative functionality of QlikView.

Synthetic Keys get created when there are more than one common field name between one or more tables. It is a composite key representing combinations of the multiple key fields connecting the tables.

‘$Syn 1 Table’ got created having the synthetic key ‘$Syn 1’. Synthetic key removal can be done using any of the below methods:

1. Renaming Fields (Using Qualify)
2. Removing unnecessary fields
3. Using Auto Number function
4. Create Link Table
5. Concatenating Similar Tables