topic Re: What is Synthetic Key? in QlikView https://community.qlik.com/t5/QlikView/What-is-Synthetic-Key/m-p/528541#M1120094 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>When two or more than one field is associated between tables then synthtic key and table is formed .</P><P>it is better to avoid it</P><P>various ways we can avoid it.</P><P>1)renaming the fields</P><P>2) commenting the filelds.</P><P>3)joining</P><P>4)concatenate</P><P>5)complex keys</P><P>6)link table find attached&nbsp; ppt will&nbsp; be helpful to you.</P><P>regards</P><P>Mahesh</P></BODY></HTML> Fri, 17 Jan 2014 15:24:03 GMT 2014-01-17T15:24:03Z What is Synthetic Key? https://community.qlik.com/t5/QlikView/What-is-Synthetic-Key/m-p/528539#M1120092 <HTML><HEAD></HEAD><BODY><P>What is Synthetic Key?</P></BODY></HTML> Fri, 17 Jan 2014 12:31:06 GMT https://community.qlik.com/t5/QlikView/What-is-Synthetic-Key/m-p/528539#M1120092 2014-01-17T12:31:06Z Re: What is Synthetic Key? https://community.qlik.com/t5/QlikView/What-is-Synthetic-Key/m-p/528540#M1120093 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #333333;">When there is more than one field that link two tables, you will get a synthetic key in <SPAN class="spelle">QlikView</SPAN>.</SPAN></P><P><SPAN style="color: #333333;"><IMG alt="Source table view.png" class="jive-image jiveImage" height="218" src="/legacyfs/online/51661_Source table view.png" style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3778c7; text-align: center; background-color: #f5faf0;" width="470" /></SPAN></P><P><SPAN style="color: #333333;"><IMG alt="Internal table view.png" class="jive-image jiveImage" height="300" src="/legacyfs/online/51674_Internal table view.png" style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3778c7; text-align: center; background-color: #f5faf0;" width="470" /></SPAN></P></BODY></HTML> Fri, 17 Jan 2014 12:32:12 GMT https://community.qlik.com/t5/QlikView/What-is-Synthetic-Key/m-p/528540#M1120093 ramkrishna86 2014-01-17T12:32:12Z Re: What is Synthetic Key? https://community.qlik.com/t5/QlikView/What-is-Synthetic-Key/m-p/528541#M1120094 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>When two or more than one field is associated between tables then synthtic key and table is formed .</P><P>it is better to avoid it</P><P>various ways we can avoid it.</P><P>1)renaming the fields</P><P>2) commenting the filelds.</P><P>3)joining</P><P>4)concatenate</P><P>5)complex keys</P><P>6)link table find attached&nbsp; ppt will&nbsp; be helpful to you.</P><P>regards</P><P>Mahesh</P></BODY></HTML> Fri, 17 Jan 2014 15:24:03 GMT https://community.qlik.com/t5/QlikView/What-is-Synthetic-Key/m-p/528541#M1120094 2014-01-17T15:24:03Z