data modeling

[q11hhg]

Hi there,

Could you please tell me how can I remove this Syn key but keep the relationship between Calendar and events, orders,

Thank you 

[NitinK7]

try to join event table and order table

[MayilVahanan]

HI @q11hhg 

Create a link table for this. 

https://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/

[rbartley]

Hi,

You could combine the Events and Calendar tables into a Calendar Events table, since you already have a date in the Events table, then you could create an autonumber field on Country and Date in both the Calendar Events table and Orders table.  That would remove the synthetic key.