topic How to remove Synthetic Key for tables loaded with different where clauses ? in QlikView https://community.qlik.com/t5/QlikView/How-to-remove-Synthetic-Key-for-tables-loaded-with-different/m-p/1174227#M381310 <HTML><HEAD></HEAD><BODY><P>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 &amp; 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 ?</P><P></P><P></P><P>TIA,</P><P>James</P></BODY></HTML> Tue, 31 May 2016 07:07:35 GMT 2016-05-31T07:07:35Z How to remove Synthetic Key for tables loaded with different where clauses ? https://community.qlik.com/t5/QlikView/How-to-remove-Synthetic-Key-for-tables-loaded-with-different/m-p/1174227#M381310 <HTML><HEAD></HEAD><BODY><P>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 &amp; 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 ?</P><P></P><P></P><P>TIA,</P><P>James</P></BODY></HTML> Tue, 31 May 2016 07:07:35 GMT https://community.qlik.com/t5/QlikView/How-to-remove-Synthetic-Key-for-tables-loaded-with-different/m-p/1174227#M381310 2016-05-31T07:07:35Z Re: How to remove Synthetic Key for tables loaded with different where clauses ? https://community.qlik.com/t5/QlikView/How-to-remove-Synthetic-Key-for-tables-loaded-with-different/m-p/1174228#M381311 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Best regards,</P><P>Andrés</P></BODY></HTML> Tue, 31 May 2016 13:27:00 GMT https://community.qlik.com/t5/QlikView/How-to-remove-Synthetic-Key-for-tables-loaded-with-different/m-p/1174228#M381311 andrespa 2016-05-31T13:27:00Z Re: How to remove Synthetic Key for tables loaded with different where clauses ? https://community.qlik.com/t5/QlikView/How-to-remove-Synthetic-Key-for-tables-loaded-with-different/m-p/1174229#M381312 <HTML><HEAD></HEAD><BODY><P>Hi James,</P><P>You cannot remove Sync Tables from where clauses, there is only one way, and it is modify your data model.</P><P>Generate new keys an rename fields to remove it, do not use where clauses.</P><P></P><P>Thanks!</P></BODY></HTML> Tue, 31 May 2016 13:42:36 GMT https://community.qlik.com/t5/QlikView/How-to-remove-Synthetic-Key-for-tables-loaded-with-different/m-p/1174229#M381312 Anonymous 2016-05-31T13:42:36Z