how to remove synthetic keys

[srujanaponnuru]

Hi All,

How to remove synthetic keys ? attached is qv file and the data model. Please suggest how to remove the synthetic keys from edit script.

Regards

Srujana

[sunny_talwar]

I am working with Personal Edition of QlikView, Would you be able to share your script and a screenshot of your data model in QlikView?

[srujanaponnuru]

here are the files.

[sunilkumarqv]

Either rename the fields which have synthetic or create a link table

[vardhancse]

Hi,

Join table Loss and Mitigation technique with the field Counterpart_Id.

Rename snapshot quarter and snapshot year.

[parthakk]

HI srujana,

U can form surrogate key to avoid synthetic key as

[Snapshot Quarter] & [Snapshot Year] & Counterparty_Id as #_serrogate_key

u have to form this key in both the tables i.e in Loss table and MitigationTechnique: table

[parthakk · Accepted solution]

and after forming the key drop these three fields

[Snapshot Quarter]

[Snapshot Year]

Counterparty_Id

and as your data exists within key, dropping these fields will resolve your problem

[srujanaponnuru]

Thank you, it worked.