Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
priyarane
Specialist
Specialist

Synthetic Keys

Hi Experts,

I have a doubt on synthetic keys, that is - what kind of scenario we can keep Synthetic keys in our Data model.

Thank you.

3 Replies
maxgro
MVP
MVP

did you read this?

Synthetic Keys

petter
Partner - Champion III
Partner - Champion III

If you use an INTERVAL MATCH it will create a synthetic key which you will have to keep.

If you get synthetic keys due to source tables you should definitely resolve them into bridge tables/link tables so you verify the need for them for yourself and others. It gives you the opportunity to put sensible field names on the generated synthetic fields also - which is important.