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

How to remove synthetic keys

Hi Folks,

 

While loading the data 6 synthetic keys are formed all the tables which are linked each other are required.

Can some help me how to remove the sys keys without concatenate table

2 Replies
salezian
Creator
Creator

Hi

What you need is link table. Take a look at this blog post:

http://www.qlikfix.com/2016/09/08/elegant-link-table-script/

 

jonathandienst
Partner - Champion III
Partner - Champion III

The synthetic keys are composite keys formed when there are multiple field shared between tables. The resolution is dependant on your data model, so it not possible give a simple solution.

Look to see if the common fields are required in both tables, don't load the fields not required, alias the values or make your own composite keys (for example, by concatenation). 

i would avoid simply qualifying the loads without trying to properly understand your data model and the analytical requirements.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein