topic Re: What is Synthics Keys and how to avoid it? in QlikView https://community.qlik.com/t5/QlikView/What-is-Synthics-Keys-and-how-to-avoid-it/m-p/604402#M1093210 <HTML><HEAD></HEAD><BODY><P>Hi Reddy,</P><P>Synthetic keys occurs when multiple (more than one) field names are common between two or more tables. This happens as QlikView determines the common filed names automatically, QlikView is a AQL tool which automatically associate common fields names. To resolve this you may rename the fields or use qualify statment.</P><P></P><P>Regards</P><P><STRONG>Advait </STRONG></P></BODY></HTML> Tue, 06 May 2014 15:41:23 GMT advait_thakur 2014-05-06T15:41:23Z What is Synthics Keys and how to avoid it? https://community.qlik.com/t5/QlikView/What-is-Synthics-Keys-and-how-to-avoid-it/m-p/604400#M1093208 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12.0pt; font-family: 'Arial','sans-serif';"> </SPAN><SPAN style="font-size: 12.0pt; font-family: 'Arial','sans-serif';">What is Synthics Keys and how to avoid it?</SPAN></P></BODY></HTML> Tue, 06 May 2014 15:29:37 GMT https://community.qlik.com/t5/QlikView/What-is-Synthics-Keys-and-how-to-avoid-it/m-p/604400#M1093208 2014-05-06T15:29:37Z Re: What is Synthics Keys and how to avoid it? https://community.qlik.com/t5/QlikView/What-is-Synthics-Keys-and-how-to-avoid-it/m-p/604401#M1093209 <HTML><HEAD></HEAD><BODY><P>See this blog post: <A _jive_internal="true" class="font-color-normal" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/04/16/synthetic-keys" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3d3d3d;">Synthetic Keys</A></P></BODY></HTML> Tue, 06 May 2014 15:37:11 GMT https://community.qlik.com/t5/QlikView/What-is-Synthics-Keys-and-how-to-avoid-it/m-p/604401#M1093209 Gysbert_Wassenaar 2014-05-06T15:37:11Z Re: What is Synthics Keys and how to avoid it? https://community.qlik.com/t5/QlikView/What-is-Synthics-Keys-and-how-to-avoid-it/m-p/604402#M1093210 <HTML><HEAD></HEAD><BODY><P>Hi Reddy,</P><P>Synthetic keys occurs when multiple (more than one) field names are common between two or more tables. This happens as QlikView determines the common filed names automatically, QlikView is a AQL tool which automatically associate common fields names. To resolve this you may rename the fields or use qualify statment.</P><P></P><P>Regards</P><P><STRONG>Advait </STRONG></P></BODY></HTML> Tue, 06 May 2014 15:41:23 GMT https://community.qlik.com/t5/QlikView/What-is-Synthics-Keys-and-how-to-avoid-it/m-p/604402#M1093210 advait_thakur 2014-05-06T15:41:23Z Re: What is Synthics Keys and how to avoid it? https://community.qlik.com/t5/QlikView/What-is-Synthics-Keys-and-how-to-avoid-it/m-p/604403#M1093211 <HTML><HEAD></HEAD><BODY><P>thankyou</P></BODY></HTML> Tue, 06 May 2014 15:48:28 GMT https://community.qlik.com/t5/QlikView/What-is-Synthics-Keys-and-how-to-avoid-it/m-p/604403#M1093211 2014-05-06T15:48:28Z