$syn table

[Anonymous]

Hi,

May someone explain me please why the system created the '$Syn 3 Table' and how should I remove it?

This Sync table causes duplicates (as you can see in the second pic).

[PabloTrevisan]

Hi Itamar,

You need to make changes in your data model, make a key between more than one field...

It happened because two tables must have just one link.

Example: JOIN, CONCATENATE or QUALIFY the tables.

take a look in this material

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/synthetic-keys.htm

[nsetty]

Check out the link from hic‌

Synthetic Keys

[Gysbert_Wassenaar · Accepted solution]

You have two tables that both have the fields Office City and Country. Qlik Sense uses the common fields to associate the tables. When there are two or more common fields then a synthetic key is created. Apparently in one or both of your two tables the Country or Office City field is sometimes empty. That means that there are combinations of Country and Office City that only exist in one of the two tables. With the result you see.

How to fix it? That depends on what you think is correct data. Should there be records where Country of Office City is empty? How should those records then be linked to the other table? You could simply rename one of the fields in one of the tables so only the one remaining common field is used to associate the tables. But you'll have to decide if that solves your problem or only hides a data quality issue.