Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to remove Synthetic Key for tables loaded with different where clauses ?

I have quite big and complex load script whose table structure shows a synthetic key with some fields. I read about a method called 'Remove Syn keys using concatenate & Link table'. But I think i may not apply this technique in my script since I am loading fact tables with where clauses. Any other effective technique to remove synthetic key ?

TIA,

James

2 Replies
andrespa
Specialist
Specialist

Hi, the reomove of syn keys always depends on your data model. Could you please post some example of any exact problem? That way would be easier to hep you.

Best regards,

Andrés

Anonymous
Not applicable
Author

Hi James,

You cannot remove Sync Tables from where clauses, there is only one way, and it is modify your data model.

Generate new keys an rename fields to remove it, do not use where clauses.

Thanks!