topic joining with one to many relationship in QlikView https://community.qlik.com/t5/QlikView/joining-with-one-to-many-relationship/m-p/922406#M652837 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Initially, there was many to many relationship between the tables.</P><P>after combining the columns it resulted in the below data model,</P><P></P><P>Can any one please lemme know is it good idea to join/left join/inner join these tables so as to form a single table.</P><P></P><P>Coz i wanna load then as a single table.</P><P></P><P></P><P></P><P><IMG alt="datamodel.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/94572_datamodel.PNG" style="height: 185px; width: 620px;" /></P></BODY></HTML> Thu, 30 Jul 2015 14:47:17 GMT markgraham123 2015-07-30T14:47:17Z joining with one to many relationship https://community.qlik.com/t5/QlikView/joining-with-one-to-many-relationship/m-p/922406#M652837 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Initially, there was many to many relationship between the tables.</P><P>after combining the columns it resulted in the below data model,</P><P></P><P>Can any one please lemme know is it good idea to join/left join/inner join these tables so as to form a single table.</P><P></P><P>Coz i wanna load then as a single table.</P><P></P><P></P><P></P><P><IMG alt="datamodel.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/94572_datamodel.PNG" style="height: 185px; width: 620px;" /></P></BODY></HTML> Thu, 30 Jul 2015 14:47:17 GMT https://community.qlik.com/t5/QlikView/joining-with-one-to-many-relationship/m-p/922406#M652837 markgraham123 2015-07-30T14:47:17Z Re: joining with one to many relationship https://community.qlik.com/t5/QlikView/joining-with-one-to-many-relationship/m-p/922407#M652838 <HTML><HEAD></HEAD><BODY><P>These might help you in choosing your joins.</P><P></P><P><IMG alt="QV_Joins.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/94573_QV_Joins.png" style="height: 441px; width: 620px;" /></P></BODY></HTML> Thu, 30 Jul 2015 14:50:37 GMT https://community.qlik.com/t5/QlikView/joining-with-one-to-many-relationship/m-p/922407#M652838 Qrishna 2015-07-30T14:50:37Z