Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

asb02512
New Contributor III

How to Remove the Synthetic Keys

Dear all.

Please help me and guide me regarding the synthetic key issue. i am a newbie. Please find the attached image, I am getting the desired result but the issue is of synthetic keys. I dont know where i am doing the mistake renaming or qualify and unqualify. How to remove the synthetic keys in the current scenario.

1 Solution

Accepted Solutions
shraddha_g
Honored Contributor III

Re: How to Remove the Synthetic Keys

Create a composite key of BRANCH_CD and CUST_SALESMAN to link Table Branches and Customer to Monthly_Sales_Activity. 2nd Key will be VNDR# and ITEM# to link Table Vendor and ITEM Master to Monthly Sales Activity.

7 Replies
shraddha_g
Honored Contributor III

Re: How to Remove the Synthetic Keys

Create a composite key of BRANCH_CD and CUST_SALESMAN to link Table Branches and Customer to Monthly_Sales_Activity. 2nd Key will be VNDR# and ITEM# to link Table Vendor and ITEM Master to Monthly Sales Activity.

shaktisinghchau
New Contributor III

Re: How to Remove the Synthetic Keys

To minimize or remove synthetic key you can concatenate the fields which is causing synthetic key like I did below.

BRANCH_CD & '|'& CUST_SALESMAN AS Key

MVP
MVP

Re: How to Remove the Synthetic Keys

Firstly - synthetic keys are not an evil that needs to be eradicated, they are a valid and efficient way to handle composite keys (association keys made up of more than one field).

In your case, you would need to decide if the association between customer and monthly sales activity should be a salesman level or at a  salesman and branch level. If the former, then you simply could not load the branch code into the customer table. If its the latter, you could create your own handling of the composite key, or you could leave the synthetic key in place.

The same analysis should be performed on the other synthetic key.

Building in your own handling of the composite key is unlikely to perform better in reload or in the front end.

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

Re: How to Remove the Synthetic Keys

Hi,

in

monthly sales activity table and

items master table you have filed like itmes#,

if you have same underlined data in that filed in both the tables,

create a..composite key with vndr# and items#,

or if you don't have same underlined data in items# in both the tables rename that in one table.

and

to avoid second synthetic key,

create composite key with branch_cd and cus_salesmen.

Not applicable

Re: How to Remove the Synthetic Keys

Simple task

Rename the fields as different which are not useful to link and make the fields same in the tables which are need to be link

asb02512
New Contributor III

Re: How to Remove the Synthetic Keys

thanks a lot shraddha

asb02512
New Contributor III

Re: How to Remove the Synthetic Keys

Thanks everyone. Issue resolved By Creating Composite Keys

Community Browser