Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
chrisjad
Contributor III
Contributor III

Handling synthetic key when adding a Master Calendar table

Hello QLikS friends, 

Please see the picture attached with my current load. 

I am trying to add a master calendar (for the sake of making the dev of the app easier as dates dimensions do not relate to each other for some period of time in the entire dataset) but when adding this master calendar, I get a synthetic key. 

Is it possible to add or link the master calendar to the current link table? 

Or do would you have another solution? 

 

Thank you

Labels (1)
3 Replies
rubenmarin1

Hi a synth key is created when more than one field exist in more than one table.

You can add the master calendar to join with the rest of the model using the Period or Date field, from this field the master calendar would generate the other fields (month, year, quarter...) once they are loaded on the master calendar remove it from them from the other tables like absences, only keep the link field in this table.

chrisjad
Contributor III
Contributor III
Author

Thanks @rubenmarin1 ,  I will try so

 

chrisjad
Contributor III
Contributor III
Author

It worked @rubenmarin1 . I actually forgot to dropped the common fields. But thanks to your explanation, I now understand better the concept of synthetic key