To remove the Synthetic Key to use following method,
1. When any two tables share more than one common field, QlikView creates a complex key, or synthetic key, to try and associate both tables through the combination of all of the common fields between them.
2. This takes the form of an additional table containing the shared fields and an additional key field added to all involved tables.
3. Suppose tables all filednames same means use the concatenate function to remove the Synthetic Key