topic Re: Synthetic Key in QlikView https://community.qlik.com/t5/QlikView/Synthetic-Key/m-p/662336#M1072038 <HTML><HEAD></HEAD><BODY><P>Hi Manish,</P><P></P><P>This is interview point of question</P><P></P><P>-- Thanks </P><P>Villyee</P></BODY></HTML> Tue, 12 Aug 2014 07:53:34 GMT vanderson009 2014-08-12T07:53:34Z Synthetic Key https://community.qlik.com/t5/QlikView/Synthetic-Key/m-p/662332#M1072034 <HTML><HEAD></HEAD><BODY><P>Hello Community,</P><P></P><P>How to identified which method is best to remove synthetic key, concatenate or link table??</P><P></P><P>Thanks and Regards,</P><P>Villyee Anderson.</P></BODY></HTML> Tue, 12 Aug 2014 07:47:54 GMT https://community.qlik.com/t5/QlikView/Synthetic-Key/m-p/662332#M1072034 vanderson009 2014-08-12T07:47:54Z Re: Synthetic Key https://community.qlik.com/t5/QlikView/Synthetic-Key/m-p/662333#M1072035 <HTML><HEAD></HEAD><BODY><P>Depends on your database....</P><P>Provide some sample data for your database... Mostly developers using Concatenate most...</P></BODY></HTML> Tue, 12 Aug 2014 07:49:29 GMT https://community.qlik.com/t5/QlikView/Synthetic-Key/m-p/662333#M1072035 MK_QSL 2014-08-12T07:49:29Z Re: Synthetic Key https://community.qlik.com/t5/QlikView/Synthetic-Key/m-p/662334#M1072036 <HTML><HEAD></HEAD><BODY><P>Villyee,</P><P></P><P>Follow this:</P></BODY></HTML> Tue, 12 Aug 2014 07:51:56 GMT https://community.qlik.com/t5/QlikView/Synthetic-Key/m-p/662334#M1072036 amit_saini 2014-08-12T07:51:56Z Re: Synthetic Key https://community.qlik.com/t5/QlikView/Synthetic-Key/m-p/662335#M1072037 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>If the synthetic key is happening because two or more fields are named alike in two or more tables, the most sensible way of making sure that you are loading the data as you want is to delete those fields repeated (for example, date in header and line, and you only need one). Another option if you are developing and not sure how to associate tables is renaming fields using AS in the script:</P><P></P><P>LOAD Field AS Field.1</P><P>FROM ...</P><P></P><P>Once you are sure about how you want to associate your model, then you can decide to JOIN, CONCATENATE, KEEP, etc.</P><P>Miguel</P></BODY></HTML> Tue, 12 Aug 2014 07:52:33 GMT https://community.qlik.com/t5/QlikView/Synthetic-Key/m-p/662335#M1072037 Miguel_Angel_Baeyens 2014-08-12T07:52:33Z Re: Synthetic Key https://community.qlik.com/t5/QlikView/Synthetic-Key/m-p/662336#M1072038 <HTML><HEAD></HEAD><BODY><P>Hi Manish,</P><P></P><P>This is interview point of question</P><P></P><P>-- Thanks </P><P>Villyee</P></BODY></HTML> Tue, 12 Aug 2014 07:53:34 GMT https://community.qlik.com/t5/QlikView/Synthetic-Key/m-p/662336#M1072038 vanderson009 2014-08-12T07:53:34Z