Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
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
Partner

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