$Syn tables - what is the purpose of them?

[#1]

Hi all,

I'm new to QlikView and I don't know what this $Syn 3 table in the picture means...

Is it just an easier way of showing joins between tables? Can't we just see joins between tables without having a $Syn table?

Thanks in advance,

Davydd

[#2]

Hi Davydd,

Please check the following post to find out more about synthetic keys:

http://community.qlik.com/forums/t/25440.aspx

Regards,

Rishi

[#3]

Hi,

The reason you have got a $Syn table is that you have more than one key, qlikview joins your tables together when the naming of a field in one table is identical to the naming of a field in a second table (Qlikview Join). In order to get rid of a $Syn table you will have to find the unique key (field) that joins your data together and those field names should be the only ones that have the same naming etc. example below.

Please correct me if my terminology is wrong or if my explanation is superficial.

Good luck

[#4]

Perfect thank you very much everyone. I didn't know $Syn meant synthetic keys... I've heard of Synthetic Keys before. Thanks again!