topic Is it possible to manually connect tables in data model? in QlikView https://community.qlik.com/t5/QlikView/Is-it-possible-to-manually-connect-tables-in-data-model/m-p/989018#M526246 <HTML><HEAD></HEAD><BODY><P>I'm having a problem about connecting entities to another. Is there a possible way how to connect entities manually from primary key to foreign key? <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> Thanks for your help! </P></BODY></HTML> Thu, 26 Nov 2015 09:29:06 GMT 2015-11-26T09:29:06Z Is it possible to manually connect tables in data model? https://community.qlik.com/t5/QlikView/Is-it-possible-to-manually-connect-tables-in-data-model/m-p/989018#M526246 <HTML><HEAD></HEAD><BODY><P>I'm having a problem about connecting entities to another. Is there a possible way how to connect entities manually from primary key to foreign key? <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> Thanks for your help! </P></BODY></HTML> Thu, 26 Nov 2015 09:29:06 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-manually-connect-tables-in-data-model/m-p/989018#M526246 2015-11-26T09:29:06Z Re: Is it possible to manually connect tables in data model? https://community.qlik.com/t5/QlikView/Is-it-possible-to-manually-connect-tables-in-data-model/m-p/989019#M526247 <HTML><HEAD></HEAD><BODY><P>The only way that Qlik allows relations between tables is by having fields have exactly the same name.</P><P>It is our opinion that things should only have 1 name.</P><P></P><P>Within Qlik there is no such thing as primary key or foreign key. This has to do with the different way that Qlik handles data.</P><P></P><P>So, your solution:</P><P>Rename fields in your script, preferably in your preceding load:</P><P>wrongFieldName as RightFieldName,</P></BODY></HTML> Thu, 26 Nov 2015 19:17:33 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-manually-connect-tables-in-data-model/m-p/989019#M526247 oknotsen 2015-11-26T19:17:33Z Re: Is it possible to manually connect tables in data model? https://community.qlik.com/t5/QlikView/Is-it-possible-to-manually-connect-tables-in-data-model/m-p/989020#M526248 <HTML><HEAD></HEAD><BODY><P>If you left the thinking in SQL logics behind you it's not difficult to create working datamodels within qlikview - have a special look on the first 3 links in <A href="https://community.qlik.com/docs/DOC-8844">Get started with developing qlik datamodels</A> but the other are of course helpful, too.</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 27 Nov 2015 12:51:44 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-manually-connect-tables-in-data-model/m-p/989020#M526248 marcus_sommer 2015-11-27T12:51:44Z